Pivot Table Row Totals

M

Mike

I developed a pivot table with grand totals and it will not show the "row"
grand totals. I changed my display settings within the pivot table options,
and it will still not show the "row" grand totals but does show the "column"
grand totals. Any help would be appreciated?

Thanks
 
L

Luke M

By definition, there can be only 1 grand total. I believe you are actually
looking for "subtotals". Select the PIvot Data button for the field you would
like to see subtotals, and double click. You should now be able to select the
option to show subtotals (sum, count, average, etc.)
 

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

grand totals in pivot table rows 5
Add AVERAGE column to Pivot Table 0
row totals in pivot table 0
How to ignore a column of numbers in Grand Total for rows 1
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table - copy specified Grand Totals 1
Pivot Table Question 1
Referencing a pivot tables Grand Totals Column 1

Top