Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share some sample data for this.
Nothing attached...
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
Hello, maybe the Dimensionality() function would help.