6 Replies Latest reply: Sep 26, 2012 7:12 AM by Jonathon Artingstall RSS

    Expression in my pivot table - exceeding 100%

      Hello,

      As you surely will tell from this post, I am new to QV10, and have a problem creating an expression in a pivot table.

       

      My data has Country and State as dimensions.


      My expressions are

       

      SUm({<month_name ={June}>} (Numerator)/(Denominator))

       

      Same for July, August etc

       

      This works fine when the pivot table is opened down to State, but when grouped up to Country, the % for the country is just the addition of all the state %'s; not the recalculation.

       

      Please can someone show me where I am going wrong?


      Thanks in advance.

       

      J