5 Replies Latest reply on Nov 27, 2012 5:08 PM by JianPing ShangGuan

    How to create caculate this filter?

    JianPing ShangGuan

      See below chart: filter out orders which has more than 1 customer included in 1 order ID. I made this one time filter, how to have an automatic filter then?

      Condition I set: 1. add index by (pane down) 2. select orders which Index>1 3. keep only this order and remove filter on index.

      I guess can set one formula on OrderID, but failed by my level. guess this can be very help for check in other cases.

      Capture.PNG