Chart losing 12m rolling data upon filtering

Hi there,

I’ve created a chart, which summarises 12m rolling sales data using sales information from 2015 onwards. The 2015 data is needed to calculate the 2016 results, but I don’t want to see the 2015 data. If I apply a filter it messes up the rolling sales calculations as presumably it ‘loses’ the 2015 data. How can I keep the rolling calculations working but not show certain periods on the graph?

Regards,

Gary.


trigaz77 (BOB member since 2017-03-23)

Further to the above I’ve discovered the nofilter function which works fine when the data is in a table, but doesn’t seem to work for filters applied to a graph. Is this right?


trigaz77 (BOB member since 2017-03-23)