Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts, I need to fix one dimension in set analysis but still let others dynamic, E.g. sum({<date={"$(=max(date))"}>}sales)
For the other hand, I need to filter by country or department, but always get the last available date. I need something like sum({<date={"1(=max(date))"}>}sales)
Thanks!
Try the P() function
Sum({<date=P({1<date={"$(=Max(date))"}>}date)>}sales)
Thanks @jwjackso but Date it's still dynamic. I want to permanently fix Date as max(Date) and ignore any future Date selections as well
May be this
Sum({<date = {"$(=Max({1} date))"}>} sales)