Sorting a calculated dimension

[newqlik2017]

I have the below columns in a pivot table from a single calculated dimension.

2Q 2016

3Q 2016

4Q 2016

1Q 2017

How do I sort them to be in above sequence? I get the below result when using =Only({1} Dim) in Sort tab => Expression

1Q 2017

2Q 2016

3Q 2016

4Q 2016

[prat1507]

Hi use in expression

right(Dim,4)*1000+left(Dim,1)

and sort in Ascending order

Regards
Pratyush

[krishnacbe]

If you have a Date column, you an use that in sort expression and sort in Ascending Order

[sunny_talwar]

Do you have a date field? May be this

Max({1} Date)

[newqlik2017]

That worked, Sunny. Thank you.