1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/i-love-dregins
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com