function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Sorting formula filed values in reports

Hi ,
I am getting formula fileds based on clased date  like Q1 FY2014,Q2 FY2014..........Q1 FY2015,Q2 FY2015..

Now i am using this field in x axis but the values are sorted like Q1 FY2014,Q1 FY2015 like this way . but i want Q1 FY2014,Q2 FY2014,Q3FY2014,Q4 FY2014,Q1 FY2015,Q2 FY2015.

Can any one suggest me to come out this .

Is it possible to change your formula to display as FY2014 Q1, FY2014 Q2..... FY2015 Q1, FY2015 Q2? This way it should sort correctly. 

Or you can create another formula follows the above pattern and sort by asencing in the reports. When you display in the front end, you can choose the original formula.