I will give you the background b4 asking the question.
Brand Manager 1 looks after the following Brands
Brand Manager 2 looks after the following Brands
Light Blue stock
I have a simple report with a parameter that selects the Brand Manager, the report then will list their Brands and their sales for a particular month.
I've been asked when selecting BM1 that his Blue brand sales include sales from Light Blue (which belongs to BM2)
and visa vesa when selecting BM2
Is this possible?