Average of Month sales by Quarter

[Rose1]

I am trying to figure out how we can put in Quarter value the average of each month sum . 

What I need is to  calculate the sum of  the sales for Jan , Feb , March and then calculate the average of the three months which will be the value of my quarter in my pivot table .

Any suggestion would be much appreciated . 

[JordyWegman · Accepted solution]

Hi Rose,

Try: Aggr( NoDistinct Avg( {Yourvalue} ) , Quarter )

Or do you need the normal values at month level and only need the Q1 to be the 38,706?

Jordy

Climber

[Rose1]

Hello Jordy ,

Thank you for your reply .

Exactly I need to have the sum of values for each month and at quarter level I need to have the average of the 3  months  .