Home » Questions » Computers [ Ask a new question ]

How can I add a calculated field to a pivot table that shows the difference between two series of data?

How can I add a calculated field to a pivot table that shows the difference between two series of data?

My underlying pivot table has the following columns - ProjectName, Type, Year, Budget. The data shows information for 2009 and 2010 for the same ProjectName and Type. I can pivot this to get a table of the data but how can I add some calculated columns to show the difference between 2009 and 2010 for each entry?

Asked by: Guest | Views: 84
Total answers/comments: 1
Guest [Entry]

"There's no easy way of doing this AFAIK.

You could set Year as a column field, and then right-click on the data field > Field Settings and change it from a normal Sum to 'Difference from' / Year / (previous). This is a fairly awful solution, as you'll notice when you try it, but it's all I've found so far.

The only other way I know is to add a simple spreadsheet formula to the column to the right of the table. An equally poor solution but it does work and might be suitable for your needs."