Forum Discussion
Table Visual Sorting
No changes to the table visual.
Steps i take are:
1. Select field to sort from field list.
2. Under Column Tools in the header select 'Sort by Column'
3. Select the 'sort order' column and the table should update to reflect the ordering.
4. If you add additional columns and the ordering changes, just reclick the column header you want to sort on or follow the image PhilipTracey provided.
Hi Roger,
Once you have selected the column to include your table you can select 'sort by column' to sort this column by the 'sorting column' without having to show it in the table.
Regards,
John
Hi John,
So the sorting you mention is done in the table view?
Unfortunately the table visual still sorts by the first column added to it, it ignores the sorting in the table view.
If the "sorting column" isn't present in the table visual I am not able to "sort by" it in the visual.
Was that what you meant or am I missing something?
Regards,
/Roger
Hi Roger,
It can be done in both the report or data views. In my screenshot the left table would be the one you are trying to produce. The status column is not the first column. But the table is sorted by the sort order you can see in the right hand table even though it's not present in the first table.
Hi John!
I can't reproduce your images above, how did you do that?
Did you make any changes to the table visual?
The moment I add a column to my visual it sorts immediately...
/Roger
