Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi at all,
i have a issue or understanding problem in my bar chart. I have this following formel with expression:
Sum({<%_Key_Account={"ADDEDVALUE"},%_Key_Category={"ACTUAL"},DataMeasures={"PER"},YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -18), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1), 'MMM-YY'))"}>} DataValue)
For testing i created listboxes with the
%_Key_Account
%_Key_Category
DataMeasures
i selected the values like in the formel above. Everything worked fine, but when i deselect one of this listboxes which i want to filter in my formel, then the set analysis didn't work.
Can anyone help me?
Thanks
I found the solution which will work:
Sum({< %_Key_Account={"ADDEDVALUE"},%_Key_Category={"ACTUAL"},DataMeasures={"PER"},YearMonth ={">=$(=Date(addmonths(Max({<%_Key_Account={ADDEDVALUE},%_Key_Category={ACTUAL},DataMeasures={PER}>}YearMonth), -18), 'MMM-YY')) <=$(=Date(addmonths(Max({<%_Key_Account={ADDEDVALUE},%_Key_Category={ACTUAL},DataMeasures={PER}>}YearMonth), -1), 'MMM-YY'))"}>} DataValue)/1000000
I must add the filter into the rolling filter
I found the solution which will work:
Sum({< %_Key_Account={"ADDEDVALUE"},%_Key_Category={"ACTUAL"},DataMeasures={"PER"},YearMonth ={">=$(=Date(addmonths(Max({<%_Key_Account={ADDEDVALUE},%_Key_Category={ACTUAL},DataMeasures={PER}>}YearMonth), -18), 'MMM-YY')) <=$(=Date(addmonths(Max({<%_Key_Account={ADDEDVALUE},%_Key_Category={ACTUAL},DataMeasures={PER}>}YearMonth), -1), 'MMM-YY'))"}>} DataValue)/1000000
I must add the filter into the rolling filter