7 Replies Latest reply: Nov 27, 2012 10:08 AM by Gysbert Wassenaar RSS

    Pivot table % Totals

      Hi all,

       

      I have a pivot table as shown below. there is an expression which calculates the % which is working per line but the subtotals and totals are not working. (As you can see it shows 33.33% for each.

       

      Does anyone know how i can fix this please?

       

      The expressions used are ..

       

      Score

      Sum(Score)

       

      Percentage

      =sum(Score)/sum({<City=>}(aggr(NODISTINCT sum( Score), Country)))

       

      Capture.JPG