Calculated Dimension- from measure

StacyCui — Fri, 02 Dec 2022 07:52:56 GMT

Hi, I have an order table of CY and PY. I 'd like to calculate the OR Diff for each customer then divide into 3 types according to the OR Diff. I also create a month filter to select. But when I finish the function and select a month, it only shows the customers with OR , not for all the customer, I'd like divide the customer without the OR at that month as 'Order=0' type, How could solve it?

OR_Type=Sum({<FY={'CY'}>} ORVALUE)-Sum({<FY={'PY'}>} ORVALUE)

topic Calculated Dimension- from measure in QlikView

Calculated Dimension- from measure