Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to sort the below one which is there in one of my bar chart like the one which is given after that. Also have given the dimension for your reference.
Orginal one:
Wants to sort like this:
Dimension:
=right(START_YEAR,2)&'-'&STARTPERIOD
Looks like you have flip flopped the period and the year
=right(START_YEAR,2)&'-'&STARTPERIOD
=STARTPERIOD&'-'&right(START_YEAR,2)
If you have the dismension displaying the way you want with P#-YY but you want sorted by YY-P# just use Sort By Expression and plug in one or the other expressions from above.
Thanks for your help your help. I already tried that but it didn't give the expected result.
Hi ,
I suggest you to use " WILDMATCH " function in Sort - expression .
You have to define all ur periods sequencially & then make sort order "Ascending" . U will get result.
Bhushan N
Yes got the result!