Hello, I have a pivot table in plans grouping a sum plans on a constituent with a particular designation and fiscal year. I am trying to add a column that shows me the variance of the goal and contributed amount (Contributed amount - Goal amount). Is there a particular grouping of functions and data fields I can use to accomplish this? Thank you!
Hi Luis,
This should, if I'm understanding, be a fairly straightforward function that looks as you describe above. Here's an example: