Hi
Please assist me with my pivot table and slicer, as follows:
1. How to exclude the "grand total", col W, in the pivot table
2. How to have a slicer to filter/select the various "type" (at least 2 sets of data) in the graph.
Thank you.
Regards
Nancy
First question: How to exclude the grand total of values in Row.
Right click on any cell of the Pivot Table > Select Pivot Table Options > Switch to "Total & Filters" tab > Un-check "Show grand totals for rows"
Second question:How to select multiple types in slicer, hold the control button and select the type which you want.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks