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

(Yossi Oulu) #1

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) #2

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) #3

+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) #4

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

(Yossi Oulu) #5

+Steve Coile ok… thanks