I am trying to perform a level of detail calculation similar to the functionality available in other tools. My goal is to sum an entire column of a sheet and display that as a repeating value on each row of a column.
Here is an example of my intended goal. I know I could create a 2nd sheet in my workbook to groupsum my spend into one cell, but then I am not able to join it back up because there is no field to join on
Thanks in advance for the help!
Please sign in to leave a comment.