Comparing monthly values to average - using Aggr() ?
Dear all,
I would like to create an expression comparing the value of an expression for a month to the average (or sum) of the same expression for all months.
I think I should use an aggr function but cannot manage it.
Maybe the Excel file will be more explicit (in the yellow column, the expression I'd like to create).
I made various tries with aggr(sum(spacecrafts),NumMonth)/aggr(avg(inhabitants),NumMonth), Aggr(sum(spacecrafts),NumMonth,Planet)... but I allways get 1 as result.
If someone could help me understand how to do that...
