Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this, I've only changed the first expression, apply to the other expression columns except "Quantity Backordered" accordingly.
Thanks swuehl! This works perfectly after making some changes the the dimensions of the aggre function!!