1 Reply Latest reply on Aug 4, 2016 6:12 AM by Andrew Watson

    Showing target data for future months on a chart

    Susan Greenwood

      I am trying to create a chart that shows targets for the year held in an excel spreadsheet against sales data held in an SQL table. I have set the blend up with Targets as the Primary table.

       

      I only have target data for 2016 but I have sales data for 2014 to 2016. When I filter out 2014 and 2015 on the sheet I lose the columns for future months.

      missing months.PNG

       

      If I filter out the years on the data extract I don’t get this issue. However I also want to compare sales this year to last year so I would like to have access to earlier data in my workbook.

       

      I would also like to exclude future accumulated data on a running totals chart.

       

      Thanks in advance