Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to expressions that are working independently, but I would like to combine them into one. How would I do that?
Expression 1:
Brings back only XYZ Brand based on other dynamic selections:
sum({<[Brand]={"XYZ"}>}TotalGSV)
Brings back YTD results:
sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} TotalGSV)
I am trying to combine these because I want to bring back a specific brand all of the time but want the values to change based on my year to date selection.
Any suggestions??
sum({<Brand={'XYZ'},Year={'$(=only(Year))'},Month={"<=$(=max(Month))"}>} TotalGSV)
Or am I not understanding?
sum({<Brand={'XYZ'},Year={'$(=only(Year))'},Month={"<=$(=max(Month))"}>} TotalGSV)
Or am I not understanding?
Thank you! That worked!!