Exclude field selections for average

[#1]

Hello,

I want to calculate the average of units sold (#) for region (Regionaam) and I have three regions; noord, west and Zuid. I want to calculate the average in pivot table but if I select one of the regions, I get the number of units sold for that region and I want to see the average instead. Please help me?!

Thank you

Best,

[sunny_talwar]

Try it with total:

Avg(TOTAL [Units Sold])

[#3]

thank you for your reply, but I tried that. this is the expression i was using.

AVG(TOTAL<LandBestemming>aggr(sum({1<LandBestemming={'NL'}, $(v.Actual) ,$(v.PeriodYear)>}#),LandBestemming))

[sunny_talwar]

Would you be able to share a sample?

Best,

Sunny

[#5 · Accepted solution]

Thank you Sunny for your help!

I found the right expression I need which is this:

Avg(Aggr(sum({< Regionaam=P(Regionaam),$(v.Actual),$(v.PeriodYear)>}[Units sold]), Regionaam)) I was using LandBestemming instead of Regionaam