1 Reply Latest reply: Mar 16, 2012 12:23 PM by Marc Livingston RSS

1 chart, 2 expressions, 2 dimension

Federico Levi

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