1 Reply Latest reply on Mar 31, 2014 7:30 AM by Joshua Milligan

    how to remove duplicate data in filter

    chenfei li

      Hi :


      I used the custom SQL to generate the data connection ( a union query which combines three tables) . The join clause is not what we want in this situation. So after we union the tables, one common field in three tables becomes duplicate, which is a filter in our report. So how to solve this problem when keeping this data connection?

      ( the field is 'market 'which contains 100 different markets in total)

      Thank you very much and i appreciate your help!