Why does my second pivot table have more Total & Filters options than the first?
On one spreadsheet, I have a pivot table (with data from PQ) and in Pivot Table Options, under Totals & Filters, I can see these options:
Grand Totals
-Show grand totals for rows
-Show grand totals for columns
Filters
-Subtotal filtered page items
-Allow multiple filters per field
Sorting
-Use custom lists while sorting
In my other spreadsheet, I have another pivot table (with different, but similar data from PQ) and under the same tab I see this:
Grand Totals
-Show grand totals for rows
-Show grand totals for columns
Filters
-Include filtered items in totals
- Mark totals with \*
-Include filtered items in set totals
-Subtotal filtered page items
-Allow multiple filters per field
-Evaluate calculated members from OLAP servers in filters
Sorting
-Use custom lists while sorting
Why do I have more options available (bolded) in the second pivot table options, and is there a way to make these available in the first?
[link] [comments]
Want to read more?
Check out the full article on the original site