💻 Software
How can I add a calculated field to a pivot table that shows the difference between two series of data?
Fresh5 days ago
Mar 15, 202671952 viewsConfidence Score0%
0%
Problem
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 f…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I add a calculated field to a pivot table that shows the difference between two series of data?
Low Risk
In Excel 2010, Put your cursor in one of the Year headings, either 2009 or 2010. Options > Fields, Items, Sets > Calculated Item It's not a calculated field, it's a calculated Item within the Year field - that's the key point!
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix