Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I want to know if this is possible with a Set Analysis to make an expression giving the previous month when the field month is a dimension of my chart ?
Here the Set Modifier would be dynamic and specific for each months ?
Solving this problem would help me to calculate the variation between months.
I don't want to modify the model with the script by placing the value of the previous month on each corresponding row.
Is there somebody who have a solution for this ?
Thanks,
Vincent
PS : I attached an application trying to illustrate my problem
HI
PFA
Use before() function.
Hope it helps
HI
PFA
Use before() function.
Hope it helps
Hi pretty cool what you did here. but what if I want to have the variance result in a line chart? I tried to change this to a bar chart, but it when I do this change all the information goes blank.
Thanks and best regards,