hi, this is my firt post and this is my first project
i have this table
this one i can create
but i can't create this one
the total is calculated by adding the total of each january (4+6+6)
and the avarege is the avarege of (4,6,6) i.e in this case (4+6+6)/3
can anyone help me.
Your formula for calculate average are wrong
you can use:
Sum(total) / count(distinct year)
Sum(qty) / count(distinct year)
i only have to add the month
avg(aggr(sum(qty), year, month))
the average its ok, but it returns the average of my selection, i want the average of all the data.