6 Replies Latest reply: Feb 6, 2015 10:17 AM by ioannis giakoumakis RSS

    Sum of averages in a straight table

    Luis Menendez

      Hi,

       

      I have a straight table whith a expression avg().

       

      06-02-2015 14-24-23.png

       

      The values in "Ambar", "Esmeralda",...etc are the values of a dimension , they are average values this is right.

      The values "Punta Cana", "Riviera Maya" and "Samaná"  are values of another dimension, they are also average values, but I would like they where sum values so "Punta Cana" = 2904 instead of 968 , etc.

       

      How could I get a sum of averages instead of an average of averages whitout losing this format?

       

      Thanks