LY Value in Year wise 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.

Please see attached QVW

[somenathroy]

PFA....

Regards,

Som

[#3]

PFA

Regards,

Kabilan K

[#4]

Thanks for reply and sorry that's not I want .

Please see attached image with view (I reformatted in to Paint) and table view of actual data.

I want to do the shown in image.

Note : In the attached view it is showing 2011 value on axis of 2012

and 2010 value in 2011 axis likewise

Please suggest me

[#5]

Thanks for reply

I can't do this in data model because actually I am using date(DD/MM/YYYY) instead of year .

For sake of simplicity I have used year in this example.

Please find attached image

So If you could manage to get it done on set analysis withour touching data model and it would be much helpful for me.

[#6]

Hi,

PFA.

U can use the above function for this.

Regards,

Kabilan K.

[#7]

Thanks for quick reply .

But that also didn't work for me.

I have updated data model with actual data model I have in my project.

Now I want to modify set analysis so that It will give result as shown in another attached image.

[SunilChauhan]

in  script

use Year +1 as your fieldname

and  use in dimesion

and for previous Year

use  in expresion

sum({<Year={$(=Max(Year))}>} amount)

or if u want Previous YTD then in expression

sum({<Year={$(=Max(Year))},Month={"<=$(=Max({<Year={$(=Max(Year))}>}Month))"}>} amount)

hope this helps

[#9]

Hi,

PFA.

Regards,

Kabilan K

[#10]

Thank you very much . Helps a lot.

Need one more help . In my chart there is cyclic drill for month

So when user selected month then I need to show data like

1) on Mar 2012 axis there should be Mar 2011 quanity on LY quantity

2) on Feb 2012 axis there should be Feb 2011 quanity on LY quantity

Please find attached QVW

Thanks is advance