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?
[TABLE="width: 693"]
<tbody>[TR]
[TD]Period[/TD]
[TD] # of Paid Invoices[/TD]
[TD] # of Invoices POT[/TD]
[TD] % of Invoices POT[/TD]
[TD]AWPD[/TD]
[TD]% of Blocked Overdue[/TD]
[/TR]
[TR]
[TD]01_JANUARY[/TD]
[TD]3432[/TD]
[TD]2234[/TD]
[TD]65,09%[/TD]
[TD]56,6[/TD]
[TD]9,79%[/TD]
[/TR]
[TR]
[TD]02_FEBRUARY[/TD]
[TD]2259[/TD]
[TD]1600[/TD]
[TD]70,83%[/TD]
[TD]49,1[/TD]
[TD]10,26%[/TD]
[/TR]
[TR]
[TD]03_MARCH[/TD]
[TD]3090[/TD]
[TD]2206[/TD]
[TD]71,39%[/TD]
[TD]53,5[/TD]
[TD]8,92%[/TD]
[/TR]
[TR]
[TD]04_APRIL[/TD]
[TD]2541[/TD]
[TD]1896[/TD]
[TD]74,62%[/TD]
[TD]48,9[/TD]
[TD]9,46%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]11322[/TD]
[TD]7936[/TD]
[TD]70,09%[/TD]
[TD]52,9[/TD]
[TD]9,59%[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 693"]
<tbody>[TR]
[TD]Many thanks for all ideas!
BR[/TD]
[TD][/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][/TD]
[TD][/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][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 693"]
<tbody>[TR]
[TD]Period[/TD]
[TD] # of Paid Invoices[/TD]
[TD] # of Invoices POT[/TD]
[TD] % of Invoices POT[/TD]
[TD]AWPD[/TD]
[TD]% of Blocked Overdue[/TD]
[/TR]
[TR]
[TD]01_JANUARY[/TD]
[TD]3432[/TD]
[TD]2234[/TD]
[TD]65,09%[/TD]
[TD]56,6[/TD]
[TD]9,79%[/TD]
[/TR]
[TR]
[TD]02_FEBRUARY[/TD]
[TD]2259[/TD]
[TD]1600[/TD]
[TD]70,83%[/TD]
[TD]49,1[/TD]
[TD]10,26%[/TD]
[/TR]
[TR]
[TD]03_MARCH[/TD]
[TD]3090[/TD]
[TD]2206[/TD]
[TD]71,39%[/TD]
[TD]53,5[/TD]
[TD]8,92%[/TD]
[/TR]
[TR]
[TD]04_APRIL[/TD]
[TD]2541[/TD]
[TD]1896[/TD]
[TD]74,62%[/TD]
[TD]48,9[/TD]
[TD]9,46%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]11322[/TD]
[TD]7936[/TD]
[TD]70,09%[/TD]
[TD]52,9[/TD]
[TD]9,59%[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 693"]
<tbody>[TR]
[TD]Many thanks for all ideas!
BR[/TD]
[TD][/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][/TD]
[TD][/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][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]