- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sort a column by another column principle
Hi everyone, I have a table like this
I would to visual a table with Parent_Index and Index as Column Label like this
I want to sort weekday in order so I create the Order_id columns, but I can not sort Index Column by Order_id columns
I just do not really understand why I am wrong and how to done it.
I will be appreciated for your help. Thanks in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add a composite key (Index+parent index) and change the order_id column to consecutive numbers across that composite key as needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add a composite key (Index+parent index) and change the order_id column to consecutive numbers across that composite key as needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But when it comes for visualizing, I still want to use column "Index" and "Parent_Index" seperately for visual's column labels. Creating composite key and sorting it by distinct consecutive order_id seem not really help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can still do that. Try in out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It worked!! So sorry for late response.
Thank you very much.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-06-2024 07:29 AM | |||
06-10-2024 05:58 AM | |||
07-08-2024 02:22 PM | |||
07-11-2024 05:22 AM | |||
08-14-2024 07:26 AM |
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
1 |