Hi all,
I have attached an example file with where I am currently at with a Pivot Table I am working on. I am trying to calculate the variance between two columns in my pivot table, but the values are coming from one single column in my data set. I can't seem to get my calculated field to work even though it should be relatively straight forward (I have provided the three pink columns to the right to demonstrate the answers I am trying to get to).
Any help on this would be greatly appreciated!
Regards,
Joe
Bookmarks