Hi All,
I want to calculate the expression if there's no selection for Unit type then it should show sum of all six expression else it would show the solution as per the selection in Unit type.
I've attached the formula using for the same.
While using this expression, i can see the correct data but i am using rolling 12 months in set analysis which is not working correctly. it's showing a line chart of all dates.
Can you please check and help me with correct formula so it can show results for rolling 12 months based on my requirement.
Regards,
Sumit