Excel 2007 - Subtotals Below the Data in Pivot Tables

  • Thread starter Thread starter TB in DC
  • Start date Start date
T

TB in DC

When I choose the subtotal feature in Pivot Tables it appears across the top
of the data. Is there any way to have them shown below the data as it did in
previous versions?

Thanks,
 
Hi,

You need to change the your layout. With the pivot table selected choose
PivotTable Tools, Design, Report Layout, Show in tabular form.

If this helps please click the Yes button.
 
Thanks Shane! You Rock!


ShaneDevenshire said:
Hi,

You need to change the your layout. With the pivot table selected choose
PivotTable Tools, Design, Report Layout, Show in tabular form.

If this helps please click the Yes button.
Click to expand...
 

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

multiple subtotals in pivot table 1
format pivot subtotals 2
Pivot Table Subtotals 1
Pivot Table Formula Problem 1
Conditional SUBTOTAL in XL210 Table 7
Pivot Table Values as a % of a Subtotal 1
How do I sort pivot table data by subtotals? 2
Average of Subtotals in Pivot Table 0

Back
Top