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

    Sum of averages in a straight table



      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?