Forum Discussion
Solved
How to filter out data in a power pivot table without values?
Hi, all. I'd like to filter out data in a power pivot table that does not have values. In the attached picture, any rows that do not have dollars in the sum of amount" column I want removed. What's t...
Hi Paul slohombre
If you right click on one of the Row Labels in your left-hand column and then go to Filter and Value Filters Choose Sum Of Amount Does not equal 0
That should sort it for you.
Good luck!
Thank you! That did the trick.
slohombre Glad to hear it. Pivot tables can be tricky beasts in that they don't quite operate like the rest of excel. there's usually a simple solution but it can be a painful process finding out!
Good luck!