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.
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
Can you upload a twbx for the forum to use? You're asking for a number of different things, some of which sound complex, so you're best opportunity to get a good and quick response is to provide a workbook containing the data.