how to calculate of last three months average sales based on my selection?

[Anonymous]

Dear All,

How can I calculate of last three months average sales based on my selection?

As an example,if I select Aug-18 then calculated average sale should be of '(June-18 + July -18 + Aug - 18)/ 3'

Thanks in advance

[Anonymous]

sent...can you please check.....

[YoussefBelloum · Accepted solution]

ok, I see your problem..

you were making selections on FMonthName and you didn't detach it from the set analysis:

try this exact expression on your AvgSales formula:

sum({<FMonthName,FMonth={">=$(=Max(FMonth)-2)<=$(=Max(FMonth))"}>}SecNetAmount)/3

[Anonymous]

Thanks dear...It works 😄

[YoussefBelloum]

‌You’re welcome

Good luck