Partial average in pivot table

[#1]

Good afternoon everyone!  I have been trying unsuccessfully to get a partial average (instead of partial sums) on the dimension "Month" as shown in the pivot table shown below.  Hope anyone can help.  Thanks in advance.

[sunny_talwar]

Have you tried

Avg(Aggr(YourExpression, METRIC, Year, Month))

[#3]

Sunny,

Tried that, both as a calculated dimension and as expression, an error message appears.

[jyothish8807]

Hi Maria,

Is this what your looking for ?

Regards

KC

[sunny_talwar]

I think this is what you need to try as an expression:

Avg(Aggr(Sum([Total MRCPhP]), METRIC, Year, Month))

I think you forgot to add Sum() when you used this has expression

[#6]

KC,

sorry, can you re-send?  can't seem to see your attachment.

[sunny_talwar]

Open this link to see the attachment:

Re: Partial average in pivot table

[#8]

Sunny,

thanks for the link. unfortunately, I am using personal edition so I can't open it....

[#9]

Will try your suggestion, thanks.