1 Reply Latest reply on Jan 25, 2018 7:06 PM by Zhouyi Zhang

    Return Distinct Products on a Filter List

    Manuel Munoz Jr

      Hello!

       

      I have the following challenge.

       

      I have a list of Regional Divisions which they may sell the same products at times in addition to unique Regional products of their own. The problem that I am having is that when I create a sales history by product if I select ALL Regional Divisions I will get "duplicate" or "inflated" values (which is normal) because the same product may have been sold in more than one Regional Division.

       

      I would like to add to the list or table of Regional Divisions one called Global Division that when chosen as part of the Division filter will return only a list of distinct products. - Please notice that this example is an analogy for something specific to our company which is of use for us.

       

      Thank you for your help!