Forum Discussion
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 the best way to accomplish this?
Thanks for any help provided.
Paul
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!
4 Replies
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!
You may apply a "Does Not Equal" 0 "Values Filters" on Row Labels to hide the Row Labels where Sum of amount is 0.
