2 Replies Latest reply: Sep 8, 2014 8:14 AM by Olle Fredriksson RSS

    Aggregated function Sum of Averages

      Hi,

       

      trying to sum the average amount for each branch as per below:

       

       

      Sum(aggr(avg(Balance),Branch))

       

       

      When selecting one time (ie 09:00) Im getting the correct value.

      However, Problem is I cannot plot these values in a graph (hour as dimension), neither can I show these values per hour in a Pivot.

      Im missing something here. Any clues?

       

      Sample file attached.

       

      Regards,

      Olle