Hello,
I am trying to create a master dimension using two overlapping dimensions. For example, I have Highway Products and Highway Customers, let's say that Highway Products have $5M in sales and Highway Customers have $5M in sales, but $2M of that is overlapping (think venn diagram) so instead of $10M I need to show the correct amount of $8M ($3M from Products, $3M from Customers, and the $2M in overlapping sales).
I need users to be able to filter to just "Highway" and have it show that $8M. Both dimensions have 1/0 flags, so I need some kind of Master Dimension that says something like:
IF(HighwayProduct = 1 or (HighwayCustomer = 1 and HighwayProduct != 1),'View Highway', 'View Non-Highway')
Let me know if I need to provide further clarity and thank you for your help!