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)
![1.png 1.png](/t5/image/serverpage/image-id/95225i446CB44CA235FA11/image-size/large?v=v2&px=999)