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!
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!
