How to explode dimension into an expression

[#1]

Hi,

I need to calculate the year's total customer into a month dimension.

This is the case

Month	Month's TOT	Year's TOT
2014-09	12	66
2014-10	15	66
2014-11	13	66
2014-12	16	66
2015-01	14	31
2015-02	17	31

How can write "Year's TOT" expression?

Is it possibile? How can solve this problem?

Regards,

Roberto

[giakoum]

see attached

[alexandros17]

Is this what you need?

[#4]

Thank you!!!!

[#5]

Not properly, I want the sum for each year.

[#6]

Is it possible obtain the same result without displaying the Year dimension?

[alexandros17 · Accepted solution]

Here it is

[#8]

Yes, now it's what I need.

Thank you!

[#9]

Ok, now how can calculate total of the previous year and total of the previous n months?