I have volume output of pivot table with Actual, Plan and Prior and I have added another volume column in same pivot table with field show as % difference from base field "Year" and Base item "Plan" but output is showing all 3 columns but I want only difference against plan.
Is there any way I can have only difference % against plan without other columns?
Is there any way I can have only difference % against plan without other columns?
Month | Actual | Plan | Prior | Actual | Plan | Prior |
Jan | 8672 | 850 | 8705 | 2% | 2% | |
Feb | 6080 | 6009 | 4171 | 1% | -31% | |
Mar | 4230 | 3729 | 5232 | 13% | 40% | |
Total | 18982 | 18242 | 18108 | 4% | -1% |