I have a table format view with multiple columns/fields:
- Date
- Title
- Room
And data that looks like this table (as an example):
| Date | Title | Room |
| 4 June 2016 | Yellow-Green | Apple |
| 4 June 2016 | Sky Blue | Orange |
| 1 June 2016 | Magenta | Apple |
| 4 June 2016 | Yellow-Green | Grape |
I want to sort the data in the table at multiple levels:
- First by Date in descending order
- Second by Title in ascending order
- Third by Room in ascending order
So from the data given, the table would sort in this order:
| Date | Title | Room |
| 4 June 2016 | Sky Blue | Orange |
| 4 June 2016 | Yellow-Green | Apple |
| 4 June 2016 | Yellow-Green | Grape |
| 1 June 2016 | Magenta | Apple |
Please note that the data all still needs to be in a single table, rather than splitting into multiple tables, thank you.
The effect I'm trying to achieve in how it's like in Excel -- wherein you can sort the cells by levels -- for instance, first sort by Column B, then sort by Column D, etc.
How can I achieve this in Drupal 7 views without writing/editing any code?
Thanks very much in advance for any help.
(I've edited this question to hopefully clear things up.)