5 Replies Latest reply: Oct 24, 2013 11:23 AM by Jason Michaelides RSS

    %'s in Pivot Table

    Wilfredo Gonzalez

      I'm using a pivot table to group costs by two dimensions. 


      - When dimensions are expanded %'s are calculated correctly.

      - When dimensions are contracted %'s are incorrect.  QV is summing %'s instead of calculating them at total level.


      Any idea of how can this be fixed?

      This is the Expression calculation:


      sum({<WO_State={'Closed'}>}[Cost of Scrap]/VOP)


      As you can see, I'm using a Set Modifier.