I've made a rather large pivot table with maybe 10 values - now some of these values I need to filter. So I would like to use the filter greater than or equal but it doesn't appear anywhere.
I remember doing this before in a pivot table... When I choose sort now I can only sort smallest to largest or vice versa and when I do More sort options it's not in there either.
Edit:
After closer inspection I realize I can't add data filters to the columns. It only says clear and when I try to clear data nothing happens.
Edit #2:
At another closer inspection I need to use Slicers - which was even more complicated. How do I filter a column on greater than or equal to X using slicers?
Any ideas?
Thanks.
Bookmarks