I am trying to do the following in a single plot (even if two charts are being used, that would still be acceptable).
The data-set is at Month-Product-Market-Manufacturer level. I need to create a view which shows aggregated previous 3 months of sales, aggregated previous 6 month of sales, aggregated previous 12 months of sales and aggregated current year sales.
Each of the red dots can be assumed to be sales overall and each of the blue dots can be assumed to be cost overall for each of P1, P3, P6, P12 and YTD
Any help is much appreciated!
Thanks & Regards,