Pivot Table & Percentages

[karlitob]

Hi all,

I have a the below pivot table. I have a formula which produces true and false. For this particular month in State 1, True is 0 where False is 4. So i want to show a percentage for a report I have to do, which gets updated every month. I only want to show the percentage of true against the total for every state.

You can see my below example in terms of number, but I want to show a total percentage for each state for true, and not false. So in my below I want it to say 0%.

How do I do this? Thanks in advnace,


January 2019
[TABLE="width: 686"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD]False[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]State 1[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]State 2[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]State 3[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[/TR]
</tbody>[/TABLE]



January 2019
[TABLE="width: 686"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD]False[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]State 1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]State 2[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]State 3[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]14[/TD]
[/TR]
</tbody>[/TABLE]

 

[karlitob]

Appreciate any advice