How to display previous year value in year wise line chart ?

[#1]

Hello All ,

I am working on sales dashboard where it need to display previous year value in line chart where dimension is year.

Below is data which used to build the chart

Saleyear Saleqty

2007       100

2008       150

2009       180

2010       190

2011       175

2012       125

I have tried with set analysis but didn't work.

[#2]

Can't be usefull in my case that why not tried .

Please see reply given by me to Nirav Bhimani

[#3]

Correct. Can you help me on this.

FYI

Please see reply given by me to Nirav Bhimani where I have attached QVW file.

[#4]

didn't work . Please see reply given by me to Nirav Bhimani

[katharinakostka]

Hi Kit,

I am courious: did you find an answer? And if yes:would you share it?

Regards