Need help with previous Quarter period

[#1]

Hi All,

I have one field period like 2015-Q1, 2014-Q4 , 2014-Q3 ... etc.

so i want current period comparison 2015-Q1 and previous period 2014-Q4 data. so any one can tell how can i achieve this ??

Thanks in advance !!

Deepak

[#2]

Hi Tresesco, I need output in one single row here I am geeting two different rows.

[tresesco]

Ideally, this should have been handled in your data model. Otherwise, you have to walk an extra mile. PFA

It might look a bit complex and the approach taken is not suggested to follow unless, there is no way you can go back to the script and work on the model.