yaer & quarter

[Anonymous]

hi,

i load in script feild with "year & quarter".

i want in pivot when i chose 2014-q4 , to see detail from Previous quarters.

i use this - count({<year-q={"$(=Max(year-q)-1))"}>}tools)

thanks'

yarin.

[ecolomer]

And what is the question?

Can you explain more, please?

[#3]

Hi Create Two Variables for Current Quarter and Last Quarter and use them in the Expression, if you can't do it please share some sample data.

Regards

John

[avinashelite]

try like this :

create a variable with this expression:

vCurrentQuarter

subfeild(getfieldselection(year-q),'-',1)&'-'&'q'&(Num(purgechar (subfeild(getfieldselection(year-q),'-',2),'q'))-1)

then

count({<year-q={"$(=vCurrentQuarter)"}>}tools)