I want, a chart with in abscissa 24 months, and in coordinate the amount of sales in euro. And I want one line per department.
The difficulty is that I only want to display lines which have a value for a month during these 24 months, that is upper at the average of its 6 previous months + 10%.
Example: I display the sales of the Accessories department during the period 2014 and 2015.
If the sales in june 2015 are upper of the average of sales per month + 10% for this department between december 2014 and may 2015, the line is visible.
If the sales in june 2015 are lower of the average of sales per month + 10% for this department between december 2014 and may 2015, the line is NOT visible.
I take june 2015 in the example, but I have to test each month with the 6 previous months of these months.
Thanks for your help