Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use $_1
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
Hi,
$1 - previous selection.
$_1 -- forward selection
Regards,
@Sub2u