Hi all!
I would like to set a pivot table grand total to show just last value.
So for column % of Blocked Overdue I would like to have in total value 9,46% (last value). Is this possible?
<tbody>
</tbody>
<tbody>
</tbody>
I would like to set a pivot table grand total to show just last value.
So for column % of Blocked Overdue I would like to have in total value 9,46% (last value). Is this possible?
Period | # of Paid Invoices | # of Invoices POT | % of Invoices POT | AWPD | % of Blocked Overdue |
01_JANUARY | 3432 | 2234 | 65,09% | 56,6 | 9,79% |
02_FEBRUARY | 2259 | 1600 | 70,83% | 49,1 | 10,26% |
03_MARCH | 3090 | 2206 | 71,39% | 53,5 | 8,92% |
04_APRIL | 2541 | 1896 | 74,62% | 48,9 | 9,46% |
Total | 11322 | 7936 | 70,09% | 52,9 | 9,59% |
<tbody>
</tbody>
Many thanks for all ideas! BR | |||||
<tbody>
</tbody>