Wanted to get your eyes on this to see if i am doing this the correct way.
You normally say try and merge on as many lookup tables into the facts.
In this situation It has been really difficult to merge on pretty much nothing - as the Rows of Data is too big.
Am I doing the right thing here by creating a supporting table (top section)
1-2Many. (filtering both way) .
I found if the filtering is only single the “total sale” number is static in 2nd screen shot u see.
If you can please give me your views, advice on how to handle this level of complexity please.
Much appreciated - thanks in advance.