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

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#financial modeling with spreadsheets
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#conversational data analysis
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#automation in spreadsheet workflows
#intelligent data visualization
#no-code spreadsheet solutions
#Excel compatibility
#Pivot Table