Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You may forget to define the variable for vLy
Sum(Value)/
Sum({<Year = {"$(vLy)"}>}Value)
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.
I didn't follow you, What is your intention to show. Would you share expected result
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.
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