Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
A client ask for the next things...
I have a bar/line chart with a dimension of year_week (2010-1, 2010-2, etc).
1 line expression is quite simple.
The other one has to do the following:
Show acumulated sales by year in the current/selected week.
If we are in the 11 week of the year, I need for every year a bar in week 11 with the YTD sales.
I found a workaround using 2 graphs (and making the front transparent) and with an auxiliar table for the weeks acumulation
2010-1 2010-1
2010-2 2010-1
2010-2 2010-2
...
Does anyone imagine a solution but in only 1 chart?
Regards
Federico
Rangesum(Above(sum(sales),0,Week))
This should accumulate the number of the current week back
IE if week is 11 it would sum the sales for the past 11 weeks
Rangesum(Above(sum(sales),0,Week))
This should accumulate the number of the current week back
IE if week is 11 it would sum the sales for the past 11 weeks