How to calculate the sales sum of last month? and I need Chinese province ISO codes

[limingthefirst]

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!

[gautik92]

you should creat master calendar

and you can use this expression

sum({<T@MOnth={$(=Max(Month)-1)}>}T@KCSQty)

[limingthefirst]

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?

[gautik92]

can yu share the code