I have created calculated field Qno and assigned values Q1, Q2,Q3 and Q4 accordingly but it is showing like this in card ?
How can i arrange these ?
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.
No , years are not in Order by and this is for single year.
... do you have quarter in the order by clause?
@jaeW_at_Onyx, No, I am not using any orderby clause. Simply created Quarters like this.
... so use an order by clause on quarter if you want it to sort by quarter.
Thank You so much . It worked Thanks..