Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am looking for the following output
Year | MaxDate | Sales on MaxDate
2020 | 31/03/2020 | 10
2019 | 31/12/2019 | 20
2018 | 31/12/2018 | 30
I can't get to a formulation/set analysis that allows me to use the maxdate in the set analysis.
Please advice.
Hi Harsha,
Try like below
Sum({<Date={$(=Chr(39)&Concat(Aggr(Date(Max(Date)),Year),chr(39)&','&chr(39))&chr(39))}>}Sales)
Hi Harsha,
Try like below
Sum({<Date={$(=Chr(39)&Concat(Aggr(Date(Max(Date)),Year),chr(39)&','&chr(39))&chr(39))}>}Sales)