Help with value fields in Pivot Table (calculated/ item field?)

[rrahman]

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

---

[TABLE="width: 669"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD]Bank Code[/TD]
[TD](Bank X)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum of Bank Parent Apportioned Net Revenue GBP[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD] 2,013[/TD]
[TD] 2,014[/TD]
[TD] 2,015[/TD]
[TD] 2,016[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]Consumer/Retail[/TD]
[TD="align: right"]453576852[/TD]
[TD="align: right"]306792228[/TD]
[TD="align: right"]308110621[/TD]
[TD="align: right"]76477836[/TD]
[TD="align: right"]1144957537[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD="align: right"]127961640[/TD]
[TD="align: right"]161322177[/TD]
[TD="align: right"]145386786[/TD]
[TD="align: right"]64972730[/TD]
[TD="align: right"]499643333[/TD]
[/TR]
[TR]
[TD]Agriculture[/TD]
[TD="align: right"]6624737[/TD]
[TD="align: right"]17501781[/TD]
[TD="align: right"]8314736[/TD]
[TD="align: right"]2300197[/TD]
[TD="align: right"]34741451[/TD]
[/TR]
[TR]
[TD]Beer, Spirits and Tobacco[/TD]
[TD="align: right"]4922172[/TD]
[TD="align: right"]5938806[/TD]
[TD="align: right"]8576409[/TD]
[TD="align: right"]39496428[/TD]
[TD="align: right"]58933815[/TD]
[/TR]
[TR]
[TD]Consumer - Other[/TD]
[TD="align: right"]22834044[/TD]
[TD="align: right"]21484200[/TD]
[TD="align: right"]37911201[/TD]
[TD][/TD]
[TD="align: right"]82229445[/TD]
[/TR]
[TR]
[TD]Food and Non-Alcoholic Beverages[/TD]
[TD="align: right"]92843982[/TD]
[TD="align: right"]113648022[/TD]
[TD="align: right"]76307158[/TD]
[TD="align: right"]23176105[/TD]
[TD="align: right"]305975267[/TD]
[/TR]
</tbody>[/TABLE]