Bar Chart - Display line for 30% of Previous Month's Value

[sjhussain]

Hello,

We have a bar chart displaying values monthly value. What we want to do is have another line on the chart which would display 30% of the previous month.  How would we go about doing this.  I tried using some set analysis but the problem is that how do we access the monthly value of each month? And then display 30% of the previous month.

Please find attached the chart we are trying to achieve.

Will appreciate if someone can help us.

Thanks.

[#2]

Hi Syed,

use a Combo Chart and the Above() - Function in second expression. The Argument of this function is the Name (Label) of the according Chart-Field.

See attached example.

HtH

Roland