2 Replies Latest reply: Jan 25, 2016 5:11 AM by Sunny Talwar RSS

    Sales vs Recommended Sales

    Dermot mcgoldrick

      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.

       

      Any pointers gratefully accepted!!!