7 Replies Latest reply: Oct 19, 2017 3:12 AM by Tomass Kučinsks RSS

    Column percentage over total with aggregated dimension

      Hi everyone,

       

      I'm trying to calculate the percentage of 2 values over the total in a pivot table. Everything works fine when using "Item Group" and "Year" as dimensions. The problem comes when trying to do the same but with an expression dimension.

       

      We can get the percentage using something like:

      SUM(SalesAmount)/SUM(TOTAL <Year> SalesAmount)
      

      but with my aggregated dimension, this doesn't work.

       

      I attach the QV file with my pivot table to help you understand my problem.

       

      Thanks in advanced for your help.