Last year in a table with Month/Year Dimension

[#1]

Hi guys,

I've tried to make Year vs Last Year calc in a table with year and month dimension, but the set analysis didn't work properly.

sum(Value)

/

Sum({<Year = {"=$(vLY)"}>}Value)

vLY =  Year-1

i don't know what's happened, because it's seems so simple but i can't make it work.

Any idea to solve my problem?

Thank you guys!

[Anil_Babu_Samineni]

You may forget to define the variable for vLy

Sum(Value)/

Sum({<Year = {"$(vLy)"}>}Value)

[#3]

Hi Anil , thank you for your help

the line "Act vs LY" in 2017 must be the number of 2017 x 2016

for example:

jan 2017  =  120

jan 2016  =  100

so "Act vs LY" in jan 2017 is 20%

i need that the numbers of 2016 appears in 2017 columns, otherwise i can't see the growth between this years.

thank you.

[Anil_Babu_Samineni]

I didn't follow you, What is your intention to show. Would you share expected result

[#5]

what I need is to fill  the line "Act vs LY" in 2017  with the number of 2016  in the table below show what I need 

Year	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017
Month	jan	feb	mar	apr	mai	jun	jul	aug	sep	oct	nov	dec	jan	feb	mar	apr	mai	jun	jul	aug	sep	oct	nov	dec
Value	100	200	250	30	490	700	200	340	680	300	150	350	120	230	340	654	321	683	234	190	40	335	35	123
Act vs LY													100	200	250	30	490	700	200	340	680	300	150	350

The problem is that measure must respect set analysis instead of the dimension.

[Anil_Babu_Samineni]

Still doubt, Act Vs LY means may be Current Year Sales - Last Year Sales. Here you want instead of 2017 Sales 2016 sales need to place. What was the business requirement