Sorting using multiple fields

[#1]

I need to sort a table with one dimension by mutilpe fields. I am displaying Saleman but need it in the following order. First sort by the field that identifies "Domestic" vs "Export" - the field is DE and is either a 1 or a 2. Second, I need to sort the dimension by Regeion - field  REG and numbers from 1 to 6. Third, I need to sort by Salesman number.

How can I do this?

Thanks,

Stephen

[SunilChauhan]

use interactive sort

so that if u click on top of the field or expression it will sort according to that field.

take straight table and go sort check on interactive

in pivot it is availale automatically please check

[its_anandrjs]

Hi sjcharles,

You need to create a straight table or just go to sort section and there set the dimensions sort order of the dimensins.

Hope this helps you.

Regards,

Anand

[#4]

In pivot table it is automatic only if I am displaying all of the fields. I am only displaying the Saleman field, but it need to sort by  three other field and in a specific order.

[its_anandrjs]

Hi sjcharles,

Use Straight table not pivot table then go to sort options and apply sorting criteria.In pivot it sort in single values only.

Regards,

Anand

[SunilChauhan]

at a time you can not sort on the basis of more than one field

but you can sort one by one by click on top of fields

[#7]

Looks like I will need to create a composite sort field.

Stephen