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
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:
the solution depends on the output you're looking for
do you want to display the last three months on the table with the average on every cell ? do you want to display the average on a textbox ?
would you be able to describe the expected output ?
Ruben talks about Date-related fields, like the one you're using
let's say your year month field is called: YearMonth.. try this (based on the format you shared above):
but also need to consider the sales value of previous two months