Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
I created a field called QuarterYear where I concatenated the Quarter & year fields. I now want to display this field in an descending order i.e. I want it to be sorted as Q4-2016 Q3-2016 Q2-2016 Q1-2016 Q4-2015 Q3-2015 etc. How should I go about this?
Thanks,
I've had success by sorting by the expression:
Quarter
Custom Sort
Sort by Expression
Quarter & '-' & Year
Descending Order
Let us know if this works.
Hi,
In the Sort tab, please check the 'sort by expression' and uncheck rest of the options.
Use the expression:
=Right([Your_Field],4)&mid([Your_Field],2,1)
From the dropdown choose 'ascending' or 'descending' according to your need. It should work.