Fix one dimension in set analysis, let other dynamic

[MEBG93]

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!

[jwjackso]

Try the P() function

Sum({<date=P({1<date={"$(=Max(date))"}>}date)>}sales)

[MEBG93]

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

[sunny_talwar · Accepted solution]

May be this

Sum({<date = {"$(=Max({1} date))"}>} sales)