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...
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?
Lorenzo Just leave it I would say. No harm with extra options.