Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi use in expression
right(Dim,4)*1000+left(Dim,1)
and sort in Ascending order
Regards
Pratyush
If you have a Date column, you an use that in sort expression and sort in Ascending Order
Do you have a date field? May be this
Max({1} Date)
That worked, Sunny. Thank you.