Calculate Previous data using the SET Analysis

[#1]

In current scenario requirement is to show current selected data  so i used below expression:

But I want another expression which will show the data for last six quarter data exclunding the selected one:

For example if I have selected quarter 2014-Q4 then want to show data for  quarter "2014-Q3","2014-Q2","2014-Q1","2013-Q4","2013-Q3","2013-Q2".

Any one can help me to resolve this issue

Also want to optimise the above epression please suggest

[saumyashah90]

use $_1

[francoiscave]

Hi Pankaj,

See the document below who explain the analysis clearly :

Set Analysis: syntaxes, examples

By Fabrice Aunez,

I think it will be helpful for your issue !

François

[#4]

Hi,

$1 - previous selection.   

$_1 -- forward selection

Regards,

@Sub2u