Sub-Total Column in a pivot table

D

Dan

I have a pivot chart with columns for year 2005 and 2006 with groupings
columns for quarters. I would like to add a column (Total) summing up each
year. See below:

2005 2006
1Q 2Q 3Q 4Q Total 1Q 2Q 3Q 4Q Total

Thanks for your help!

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT with Date? 3
Show data in columns 1
I am using an expression in Access to obtain a year value. 2
Pivot table 0
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
Nested Formula 3
Consolidation Table from Different Excel Tabs with Different Format 1

Top