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 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
Solution SageHi 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
- johncolley
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.
Ahh, this drives me crazy... By not using the column tool but only click the column and use "Sort Ascending" doesnt give you the same result as choosing "Sort by" under column tools.
Column tools makes the sorting stick, great job thanks a lot to all involved!