Get Previous Quarter and just Display the Date

[Anonymous]

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!!!

[sunny_talwar · Accepted solution]

In your case you don't need set analysis, but Above() function....

Above(TYQUARTER)

or

Above(TOTAL TYQUARTER)