How to filter out data in a power pivot table without values?

[slohombre]

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

[#2]

@slohombre 

You may apply a "Does Not Equal" 0 "Values Filters" on Row Labels to hide the Row Labels where Sum of amount is 0.

[#3 · Accepted solution]

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]

Thank you! That did the trick.

[#5]

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