Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I read this discussion Get Previous Quarter and the answer of stalwar1 because I have the same Problem.
Now I wonder how to display the date.
Data in the example was:
TYQUARTER
201503 |
201506 |
201509 |
201512 |
201603 |
201606 |
201609 |
201612 |
201703 |
201706 |
Solution was:
LOAD TYQUARTER,
AutoNumber(TYQUARTER) as QuarterNum
Resident ....
Order By TYQUARTER;
and then you can use this for prev. quarter
{<QuarterNum = {"$(=Max(QuarterNum) - 1)"}>}
My question:
I just want to display the previous quarters TYQUARTER in a table but the statement below dosn't work:
sum({<QuarterNum = {"$(=Max(QuarterNum) - 1)"}>} TYQUARTER)
How to do? I don't have any idea?
Result should be:
TYQUARTER
TYQUARTER | PREVIOUSQUARTER |
---|---|
201506 | 201503 |
201509 | 201506 |
201512 | 201509 |
201603 | 201512 |
201606 | 201603 |
201609 | 201606 |
201612 | 201609 |
201703 | 201612 |
Thanks a lot!!!
In your case you don't need set analysis, but Above() function....
Above(TYQUARTER)
or
Above(TOTAL TYQUARTER)
In your case you don't need set analysis, but Above() function....
Above(TYQUARTER)
or
Above(TOTAL TYQUARTER)