Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a measure which has to show data based specific accounts and sum it all up to the date selected in filter.
I have created this so far and I don't understand how to combine these two expressions in the same measure
1. Sum({$<account = {1,2,3,}>},amt)
2. Sum({$<year = {=max(year)}>},amt)
I tried creating variable for one of the conditions and still couldn't get this to work. Can someone please correct me.
This works fine, but I don't understand what happens when I use year or month instead of yearmonth.
Why do you want to use Year and Month when YearMonth together is working for you?
It didn't look that great from UI point of view. If you have any more insights, please do share.
Thank you so much for all your help.
Just so you know, you can still make selections in Year and Month fields. The expression will still give you the right output.