Forum Discussion
How to filter by sum values pivot table
Hi- I am trying to figure out how to filter within my sum values final column of my pivot table. I need to look at values higher than 500 and less than 1000 only within the values and I cannot filter...
Thank you, the problem is it will not let me do that on my last column of the pivot which is a value sum I cannot filter on this or sort as you would for any of the other columns
colbrawl Try this then. Some sort of hack that's not officially documented as an Excel feature I believe.
Select the cell directly to the right of the Grand Total column.
and put a filter on via the Home ribbon.
Now you will have a filter icon on every column in the pivot table.
- You are a savior, Thanks alot.
- An amazing useful tip - Thank you!
- Ha! Nice one!
- huge help with this one... thanks for the trick!
Riny_van_Eekelen thanks, never knew this cool hack 🙂
- Amazingly Simple Solution - You are AWESOME!!!! THANK YOU SO MUCH!!!!!
- Thank you. I only started learning about Pivot Tables this morning and the first thing I wanted to do was this!
- THANK YOU SO MUCH!!! I've been breaking my head to make it work!! Amazing hack to be honest.
Zalejo Great! Discovered it by chance, several years ago and use it every now and then.
- It definitely should have been in those Pivot Table tutorials I watched haha. Cheers!
