Aggregated function Sum of Averages

[#1]

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

[ariel_klien · Accepted solution]

Hi,

Try  sum(aggr(avg(Balance),Branch,Time))

BR

Ariel

[#3]

thanks!