ExcelBanter - Pivot table subtotals before detail

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table subtotals before detail (https://www.excelbanter.com/excel-discussion-misc-queries/12691-pivot-table-subtotals-before-detail.html)

Jeanmarie

Pivot table subtotals before detail

I'm new to pivot tables. Is there a way to have the subtotals appear before
the detail listing?

Debra Dalgleish

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

Jeanmarie wrote:
I'm new to pivot tables. Is there a way to have the subtotals appear before
the detail listing?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Jeanmarie

Got it, thanks!

"Debra Dalgleish" wrote:

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

Jeanmarie wrote:
I'm new to pivot tables. Is there a way to have the subtotals appear before
the detail listing?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 04:51 PM.