Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add option in pivot tables to remove subtotals for fields
suggestion to add option to remove subtotals for particular fields in pivot
tables. When you put more than one field in the in the "drop row fields here" in order to further break down data, it is counterproductive to have numerous subtotals within the primary perimeter selected. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add option in pivot tables to remove subtotals for fields
You can turn off the subtotals for a field --
In the pivot table, double-click on the field button for the row field that doesn't need subtotals. Under Subtotals, choose None, then click OK -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "epsoanalyst" wrote: suggestion to add option to remove subtotals for particular fields in pivot tables. When you put more than one field in the in the "drop row fields here" in order to further break down data, it is counterproductive to have numerous subtotals within the primary perimeter selected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables? | Excel Discussion (Misc queries) | |||
External Data and Pivot Tables | Excel Worksheet Functions | |||
bring back ability to format subtotals in pivot tables | Excel Discussion (Misc queries) |