Forum Discussion
Pivot table Values on Mac
Hi, so i am missing the pivot table value filter option of "not between". i need it for an assignment but there doesnt seem to be an settings page to enable filters, and i am at the current newest ve...
The Automate tab on your picture indicates you run 365 on your Mac. Below is an alternative that routes the data Table to Power Query and pre-filter the records according to the 2 parameters (in blue) on the sheet:
Of course this has a cost as it requires an aggregration (what PivotTables do) in Power Query to filter out [States] that are Not Between x and y