Sorting in Webi

[Former Member]

Hi ,

I have Scenario like

ID    Name    Count

1       A           1

1       C           2

1       B           6

1       D           7

1       F           5

1       E           6

2       A           7 

2       D          8

2       B          5

2       C          3

I want Name Field sorted on the basis of ID

Lool like:

ID    Name    Count

1       A           1

1       B           6

1       C           2

1       D           7

1       E           6

1       F           5

2       A           7 

2       B           5

2       C           3

2       D           8

Please Help.

[former_member189638]

Select the Table and Right Click -> Sorts -> Advanced .This will open the manage Sort box as shown below. Click on the Add button to add all the three columns and Select the Priorities accordingly.

[former_member182470]

Have you tried applying Sort on Name under Analysis tab?

If that alone doesn't work, you may follow "Andreas" suggestion.

[Former Member]

Hello,

you can define the sort first on id and as second on name.

go on first column, set sort, then on the second and sort this. Sorting will be combined

Andreas