Excel 2007 - Subtotals Below the Data in Pivot Tables

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,
 
S

ShaneDevenshire

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.
 
T

TB in DC

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...
 
Top