Hi, I need to show the values in the pivot table below a sa % of the total unfiltered values. The table below is filtered by Bank Code = Bank X. But I need the values to show as a % of the total Unfiltered number for each cell, by industry row on the left.
Tried changing The Values Field Settings to show as '% of Bank Code = 0' (i.e. no filter) but this returns 0.
Open to trying any way to show this bank's % of the total value for the row.
Excel 2007
<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>
Tried changing The Values Field Settings to show as '% of Bank Code = 0' (i.e. no filter) but this returns 0.
Open to trying any way to show this bank's % of the total value for the row.
Excel 2007
Bank Code | (Bank X) | ||||
Sum of Bank Parent Apportioned Net Revenue GBP | Column Labels | ||||
Row Labels | 2,013 | 2,014 | 2,015 | 2,016 | Grand Total |
Consumer/Retail | 453576852 | 306792228 | 308110621 | 76477836 | 1144957537 |
Consumer | 127961640 | 161322177 | 145386786 | 64972730 | 499643333 |
Agriculture | 6624737 | 17501781 | 8314736 | 2300197 | 34741451 |
Beer, Spirits and Tobacco | 4922172 | 5938806 | 8576409 | 39496428 | 58933815 |
Consumer - Other | 22834044 | 21484200 | 37911201 | 82229445 | |
Food and Non-Alcoholic Beverages | 92843982 | 113648022 | 76307158 | 23176105 | 305975267 |
<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>