Eliminate pivot table rows where expression is 0 (zero)

[#1]

Hi All,

I have the following pivot table. Is there a way how I can eliminate rows from the pivot table where the "Quantity Backordered" expression is equal to 0? I want to achieve this while still getting the correct Sum values for the pivot table.

I also attached the QVW to give you access to the pivot table I am talking about.

Thanks Matt

[swuehl · Accepted solution]

Maybe like this, I've only changed the first expression, apply to the other expression columns except "Quantity Backordered" accordingly.

[#3]

Thanks swuehl! This works perfectly after making some changes the the dimensions of the aggre function!!