Quarterley Average

[Rehan]

I have a monthly data for sales Sum(Sales). Now I have created a quarter field and for each quarter I would like to get avg sales /Month. For Example if Jan =50, Feb =50 and Mar = 30, I want the Q1 sales to be 130/3 or If I have only Jan and Feb I want the Q1 sales to be 100/2.

How I can accomplish that ?

[StarinieriG]

Hi,

you could try with this expression:

Sum(total <quarter> sales)
/
count(total <quarter> month)

[sugathirajkumar]

sum(aggr(sum(Sales),Quarter))/sum(aggr(count(Month),Quarter))