Can I arrange these quarters like Q1,Q2,Q3 and Q4?

Kumar619

I have created calculated field Qno and assigned values Q1, Q2,Q3 and Q4 accordingly but it is showing like this in card ?

Qno.PNG

How can i arrange these ?

jaeW_at_Onyx

do you have Year in the ORDER BY clause? if so, then Q2 could be from different years. remove everything from your ORDER BY / sorting section of analyzer.

Kumar619

No , years are not in Order by and this is for single year.

jaeW_at_Onyx

... do you have quarter in the order by clause?

Kumar619

@jaeW_at_Onyx, No, I am not using any orderby clause. Simply created Quarters like this.

Kumar619

@jaeW_at_Onyx, No, I am not using any orderby clause. Simply created Quarters like this.

jaeW_at_Onyx

... so use an order by clause on quarter if you want it to sort by quarter.

Kumar619

Thank You so much . It worked Thanks..