| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot table subtotals before detail
I'm new to pivot tables. Is there a way to have the subtotals appear before
the detail listing? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table subtotals | Excel Worksheet Functions | |||
| Pivot table. Calcualting % from subtotals. | Excel Worksheet Functions | |||
| pivot table, functions for subtotals | Excel Worksheet Functions | |||
| pivot table - subtotal below detail | Excel Discussion (Misc queries) | |||
| Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Linear Mode
