5 Replies Latest reply on Apr 10, 2012 6:12 AM by Robert Oldershaw

    Aggregate measure as a percentage of another measure

    Robert Oldershaw

      I want to be able to show a value (waste £) as a percentage of another value (sales £). I have done the calculated field to give me the result however I am struggling with the aggregation. I want to see the total waste £ as a percentage of the total sales £, not an average of the values or a sum of the % which build up the total. The sales and waste values are sums of several values in the underlying data.

       

      Any help would be appreciated.