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
<colgroup><col><col><col></colgroup><tbody>
</tbody>
January 2019
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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
| Row Labels | False | Grand Total |
| State 1 | 100% | 100% |
| State 2 | 100% | 100% |
| State 3 | 100% | 100% |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
January 2019
| Row Labels | False | Grand Total |
| State 1 | 4 | 4 |
| State 2 | 17 | 17 |
| State 3 | 14 | 14 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
