Partial Sums within a dimension

[#1]

Hi,

I'm using a pivot table. Is there a way to show partial sums for particular groups within a dimension?

I would like to calculate the partial sum for {Bank holiday, basic pay, & bonus}, one for {daily bonus, goodwill, holiday pay} etc...

Please see table below

Thanks for any help in advance

[its_anandrjs]

Can you share some sample data for this.

[Clever_Anjos]

Nothing attached...

[#4]

There is a check box option in the presentation tab of a Pivot table chart wizard of Partial sum,to show partial sum please check mark on that box

[#5]

[#6]

Hello, maybe the Dimensionality() function would help.