Forum Discussion
Pivot table Values on Mac
Autumn5420 How odd! I hadn't discovered this yet (never had a need for this feature), but it seems that the 'Not between...' filter only exists in the Windows version (see picture).
In a regular Excel table filter you can combine the 'Less than' with an OR 'greater than' to achieve the same, but that's not possible in a Pivot Table filter.
The only way I can imagine to achieve this on a Mac is to create a calculated field. Name it 'NotBeween' with a formula similar to the picture below. change the 'Value' field and limits to your specific needs.
Then place the NotBetween field into the value area of the pivot table and filter it for the value 1 (being TRUE). I attach the file that I used in the example.
it seems that the 'Not between...' filter only exists in the Windows version and Online/Web
Lorenzo Autumn5420 Now it becomes really odd. I created a workbook on-line with the filter 'not between', saved it and then opened in the desktop on a Mac. Then I did see the 'not between' option when I filtered a value column.
Closed Excel and created a new sheet. Same result. It seems you must right-click on a label from the Row field and then choose Value filter. Now you can choose 'is not between'. Didn't see that earlier. ???
Wow, not very intuitive + Nice investigation!!!
From your point of you should I then delete the Power Query alternative I just posted?
