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 |
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. |
All times are GMT +1. The time now is 03:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com