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. 

      Situation:

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