Average aggregation

[#1]

Hey,

I have build an easy example. On the left part you will see 2 textboxes with the right result and on the right part you will see aggr function. But the aggr function is wrong. How I must change these aggr function that you got the right result like in the left part?

Thank you

[sunny_talwar]

Try these:

=Avg(Aggr(Sum(Tore), Spieler))

=Avg(Aggr(Sum(Tore), Verein))

[jonathandienst]

Its not clear what you are trying to do with the Aggr function. Why do you want to "change these aggr function that you got the right result like in the left part?"

Aggr() is usually used for calculated dimensions, sum of rows and nested aggregations and should only be used if necessary as it is memory intensive.