QUERY

[#1]

how to sort this in

FW15 ,SS15 AND FW14

WHERE FW AND SS DERIVED FROM

if(YearSeason >= $(vOldYear)and Match(Mid(LocalQuarterSeason,3,2), 'PQ'), if(Match(Mid(LocalQuarterSeason,4,2), 'Q4','Q3'),'FW','SS')&Left(LocalQuarterSeason,2), 'Older')

[Anonymous]

try in your sortoder the xpression

=match(LocalQuarterSession,'FW15','SS15','FW14','Older')

[crusader_]

Hi,

Use DUAL in your script:

if(YearSeason >= $(vOldYear)and Match(Mid(LocalQuarterSeason,3,2), 'PQ'), DUAL(if(Match(Mid(LocalQuarterSeason,4,2), 'Q4','Q3'),'FW','SS')&Left(LocalQuarterSeason,2), 'Older'), NUM(if(Match(Mid(LocalQuarterSeason,4,2), 'Q4','Q3'),2,1)&Left(LocalQuarterSeason,2), 0)) )

Sort by exression is very resource consuming operation.

Hope this helps you.

Regards,

Andrei

[jagan]

Hi Sweta,

Try like this in in your Sort tab expression

=Match(LocalQuarterSession,'FW15','SS15','FW14','Older')

OR load an inline table with required order and select Load Order in Sort Tab.

LOAD

*

INLINE [

FieldName

FW15

SS15

FW14

Older]

Hope this helps you.

Regards,

Jagan.

[#5]

cant understand your script, it s gives wrong result

expression given by me is  calculated dimension

[#6]

find list of local quarter season

FW & SS derived from them

[jagan]

Can you attach sample file?

Regards,

Jagan.

[#8]

can't