Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here it is
see attached
Is this what you need?
Thank you!!!!
Not properly, I want the sum for each year.
Is it possible obtain the same result without displaying the Year dimension?
Here it is
Yes, now it's what I need.
Thank you!
Ok, now how can calculate total of the previous year and total of the previous n months?