Hi,
I've attached a sample of a pivot that I'm working on.
The pivot is made up of data for FY17 Actuals and FY18 Budget figures.
There are five revenue streams that make up this data: Recurrent, Non-Recurrent, Prior Year Residual, ICL and Fees.
Each of these streams is derived from five separate regions.
What I'm preparing is an analysis on the variance between the budget for FY18 and the Actuals for FY17.
The columns of "Variance" and "%" that are present are all calculated fields. The variance being budget less Actuals and the % being the variance over the Actuals for that particular region in that specific revenue stream.
At the end of the Pivot are the totals of the revenue streams shown by region for both budget and Actuals.
What I want to do is show the % columns as a % of the total budget; alternatively I would show it as a % of the total variance between Actuals and Budget.
For example, cell D4 would show what % -2,774,222 is of cell M9 (73,966,536) or, alternatively, it would show the % of D4 to the difference between N9 and M9.
I'm happy to add another calculation field if necessary.
When I use the format to "show as % of Grand Total" it only shows the % of the column total rather than Grand Total.
Bookmarks