Hi all!
Is it possible to set a pivot table column total to show as total just last value in pivot table.
For example I would like to have Total value for column % of Blocked Overdue 9,46% not 9,59%.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks for all your ideas!
BR
Is it possible to set a pivot table column total to show as total just last value in pivot table.
For example I would like to have Total value for column % of Blocked Overdue 9,46% not 9,59%.
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% |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks for all your ideas!
BR