help with sorting

[hopkinsc]

Hi All,

I have a name field that i want to sort by using 2 other fields if that makes sense.

basically i have 2 Sort fields as below...

Name          Sort1     Sort2

PersonA        1          154

PersonB        1          308

Total              2          1000

Avg               2           1240

so in the above example, if i sort on Sort1 and text then i will get

PersonA

PersonB

Avg

Total

but i also want to include the 2nd sort field, so what i want to get is the below result..

PersonA

PersonB

Total

Avg

Does anyone know how i can sort the same dimension using 2 other fields?

I have attached an example.

[Qrishna · Accepted solution]

See attached.

[Qrishna]

Any luck