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

    Expression in my pivot table - exceeding 100%


      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.