AnsweredAssumed Answered

how to filter unique values

Question asked by jasongan on Aug 29, 2013
Latest reply on Aug 29, 2013 by jasongan

Title

how to filter unique values

Post

     Hello, Forum,

     thank you all I know now how to get  my store filter calculation by province.

     I am stuck in another requirement.

     I have Order Dtails table, and in that tabel I have 10 filtered stores by province. like  ON_stores, AB_Stores, BC_Stores ...

     From my Order Header table is associated with the Order Details with Docket Number.

     Here is an example of the two tables:

     Order Details: (only show 2 records as example)

     Docket Number: 110

     Part Number: a12

     Qty: 100

     Zone: 1 2 3 901 902 904

     ON_Stores:  1 3 901

     AB_Stores: 2 902 904

     ----

     Docket Number: 110

     Part Number: a14

     Qty: 100

     Zone: 1 2 3 901 

     ON_Stores:  1 3 901

     AB_Stores: 2 

     ================

     My Order Header table:

     Docket number: 110

     Zone List Summary :   1 2 3 901 902 904 1 3 901  /*( = substitute (List (Order Details::Zone); ¶; " ") :  */

     BUT, I want to get Zone List Summary = 1 2 3 901 902 904. I just want to show the unique store numbers.

     I don't know how to do it in a calculation. 

     Please help.

      

     Thanks,

     Jason

      

      

      

      

      

Outcomes