Greetings ALL and Happy new Year.
I have a Pivot Table with 5 row fields and 4 fields in data area. Grand Total shows a total for entire column and group subtotals are shown below each group of data in column 2. I have disabled other group totals. Now my management wants me to show group totals for column 2 at the bottom of pivot table right above Grand totals. Not sure if that is possible. But I know that gurus here know so many ways to tackle things. Can anyone help?
Thank You in advance !
Regards,
Ash.
I have a Pivot Table with 5 row fields and 4 fields in data area. Grand Total shows a total for entire column and group subtotals are shown below each group of data in column 2. I have disabled other group totals. Now my management wants me to show group totals for column 2 at the bottom of pivot table right above Grand totals. Not sure if that is possible. But I know that gurus here know so many ways to tackle things. Can anyone help?
Thank You in advance !
Regards,
Ash.