Hi All,
I am having trouble with a requirement.
Attaching a sample data.My requirement is:
To show count of sales month wise however months should be max of order date i.e M and then M-1(Month prvs) till M-3 and rest should fall under M-4.
I am want something like this:
AugJulJunMayApr~MM-1M-2M-3>= M-4
Is it possible?
Thanks
3 risposte
Hi Ankit,
Following are the steps -
1) Create a set by taking only latest 3 months -
2) Now create a calculated field -
if [Latest 3] = False then 'Other' elseif [Latest 3] = True then str(datename('month',[Order Date])) end
3) Use this field into your sheet.
Check the attached file.
Hope this may help!
Warm Regards,
