Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the data like following
Date | Country | Sales |
1/2/2019 | IND | 5 |
2/3/2019 | USA | 21 |
3/4/2019 | JAPAN | 56 |
1/5/2019 | NW | 45 |
4/6/2019 | PAK | 33 |
1/7/2019 | IND | 11 |
2/9/2019 | USA | 33 |
2/10/2019 | JAPAN | 50 |
8/10/2019 | JAPAN | 54 |
please suggest me to get recent month sales for every country.
Thanks,
Anji.
Assuming you have a Month field like this or something similar created in the script
MonthName(Date) as MonthYear;
you can try this
Max MonthYear
=MaxString(MonthYear)
Sales for Max MonthYear
=FirstSortedValue(Aggr(Sum(Sales), Country, MonthYear), -Aggr(MonthYear, Country, MonthYear))
Anji, did Sunny's post and example app get you what you needed? If so, be sure to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know it did work. If you still need further help, leave an update.
Regards,
Brett