Cross Tab oredering

[vijay_vittal_1]

Below is a table resultant of a cross tab, I wanted to know in what order the groups (The Name is used for grouping) are arranged? I know cross tab defaults ascending order - here all characters start with the same character.

[danilang]

Hi @vijay_vittal_1 

Alphabetical sorting doesn't evaluate the number when order the values.   The ordering is done on a character by character basis.   Since the first characters of your values are all "Field ", the ordering is dependent on the characters from position 7 onwards.  Since digits are involved, strings that start with "1" are all sorted before "2"  That's why all the rows starting with  "Field 1" show up before those starting with "Field 2" 

Dan

[vijay_vittal_1 · Accepted solution]

Got it dan