This content has been marked as final.
Show 4 replies
-
Re: Point in time using Set Analysis
Jerry Jackson Mar 25, 2018 9:32 AM (in response to Tim Müller )Try
sum({<Year={">=$(=MAX(Year)-1)<=$(=MAX(Year))"},Products={'Prod1','Prod2','Prod3'}>}VALUE)
where Products is the dimension and Prod1 is a product that you want to display
-
Re: Point in time using Set Analysis
Tim Müller Mar 25, 2018 11:00 AM (in response to Jerry Jackson)Hi Jerry,
Thanks a lot, it works
-
-
Re: Point in time using Set Analysis
Jerry Jackson Mar 28, 2018 6:45 AM (in response to Tim Müller )I'm guessing Year is coming from a calendar. You could replace =MAX(Year) with a variable that is set to a 2017.
For the second, you use an If test. Check it the product sales is greater in 2016 than 2017. Something like: If(Sum({<Year={'2016'}>} VALUE) > Sum({<Year={'2017'}>} VALUE),1,0). Hide the expression, suppress zero. That should be all the rising products. Reverse it to find the falling products.
-
-