Pivot table subtotals before detail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to pivot tables. Is there a way to have the subtotals appear before
the detail listing?
 
Right-click the field button
Choose Field Settings
Click the Layout button
Select 'Show items in outline form'
Check the box for 'Display subtotals at top of group'
Click OK, click OK
 
Got it, thanks!

Debra Dalgleish said:
Right-click the field button
Choose Field Settings
Click the Layout button
Select 'Show items in outline form'
Check the box for 'Display subtotals at top of group'
Click OK, click OK
Click to expand...
 
You must log in or register to reply here.

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

How do I sort pivot table data by subtotals? 2
Pivot Table Formula Problem 1
multiple subtotals in pivot table 1
Pivot Table percentages 1
Pivot table subtotals 2
Pivot Table Default Setting 1
Pivot Tables: Subtotal only certain columns? 6
Pivot Table Subtotals 1

Back
Top