difference between columns in pivot table excel 2007
The attached sample data currently shows a total for TOA and Critical. Need to show the difference. I thought I could field settings option and select "difference from" under the show values as droplist, yet for some reason this isn't working. Also tried a calculated field, but was unsuccessful here too.
The pivot table needs to show the difference between the TOA and Critical for each FY (not the total as currently shown)
columnDifferenceSample.xlsx
The pivot table needs to show the difference between the TOA and Critical for each FY (not the total as currently shown)
columnDifferenceSample.xlsx
ASKER
sorry for the delay, I was away for the holidays. What are the steps to add the calculated item?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help.
Is that what you are looking for?
You have to create a calculated Item not an element.
Regards
columnDifferenceSamplev1.xlsx