Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a date as a filter,
However when I select a Date on that Filter, need to show all values before that date.so for that other dimension should show all the values not only possible one.
for eg: if i select 15-dec -2018 it should give data start to till date .
Hi
Create a variable which will store your selected date. like Getfieldselections(Date)
Now in document properties, select field event trigger and put a trigger like ='<='&$(vTest)
Hope this helps.
aggr(only({<[DOCUMENT DATE]= {"<=$(=Max([DOCUMENT DATE]))"}>}LOCATION_NAME),LOCATION_NAME)