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!
Can you provide a sample or make up sample workbook?