Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have the following problem.
I have a table with 3 columns in my QVD-file.
The colums are month_year, person, sales
I want to solve the following problem:
I want to know how much more ore less a person sales, compared by the last month and the month before the last month, regarding the actual month (201410 in this case)
If I generate an expression as follows:
=(if(Month(month_year)=Month(Today())-1,sales))/(if(Month(month_year)=Month(Today())-2,sales))-1
with the dimension person I only get NULL-values.
Can you help me solving this case?
Thanks a lot in advance and best Regards!
Alexander
Could you please mark my answer if you desire ....