Table view, Group and Sort Issue Lets say I ...

[Yossi_Oulu]

Table view, Group and Sort Issue

Lets say I have a table of Deals, and it has in it category for Deal size which has: 1 High 2 Mid 3 Low

4 Minimal

I would like it to sort by the number, but group rows by the label. I was thinking that using the number for the Sort and the Label for the Grouping, should do the job, but it doesn’t It looks like the sorting is taken from the group instead of the Sort fields Any idea? Thanks

[Steven_Coile]

The groups should be sorted according to the Group by column. The entries within each group should then be sorted by The Sort by ordering. The LABEL column value is only considered if it’s included in either Group by, Sort by, or both.

[Yossi_Oulu]

+Steve Coile so there is no way to sort the groups by the id but show the label as the header of the group?

[Steven_Coile]

Correct. The group header will always be the value of the Group by column.

[Yossi_Oulu]

+Steve Coile ok… thanks