Have what should be a simple scenario that I may need a little direction on.
Lets say I have 3 data sets, sales of cars, sales of spares, and a list of what we expect sales to be, ie recommended parts sales.
I have these loaded into a QV document and want to be able to show all spares sales by country etc. This is of course very easy. I then want to show what I expect the sales to be for the car population, again easy, however when I filter by country the expected list shortens, I want to show all spares regardless if they have sold or not, or if the car has sold in that country or not etc.
You have all table boxes in your attached qvw, are you trying to do this in a table box object? I think you might be better off doing this in a straight table by using set analysis for spares' expression. Something like this: