Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I have 2 questions
1.
How to calculate the sales sum of last month?
Example ,if I select 201501,I need the sales sum of 201412,
this is my expression:
Sum({$<T@Month={12},T@DisLevel>}T@KCSQty)
2.
Do you have Chinese province ISO codes of SVG map? and where can I find it?
thx!
you should creat master calendar
and you can use this expression
sum({<T@MOnth={$(=Max(Month)-1)}>}T@KCSQty)
Hi Gowtham Kesavan
thanks for your response.
I have already creat calendar,but the point is when I select 201501,the result is null,
If Max(Month)-1=201500 or not?
can yu share the code