Is it possible, without resorting to programming, to sort a pivot table by multiple columns, conceptually similar to a t-sql order by column1, column2?
the following table is a pivot table report which does not sort as desired. I selected a cell in Total to sort ascending, then thought I could select a cell in column 2 to add a secondary sort, but that it is not the case.
Row Labels comes from Row fields, and Column 1, Column 2 comes from Column fields, and Total comes from Values fields.
I thought sorting would be trivial, but alas it is not.
when I sort by only Total, the sort is correct. Sorting by Column 2 then sorts correctly, but it does not preserve the primary sort of the Total column.
Row Labels | Column 1 | Column 2 | Total |
Music | 0.071428571 | 0.071428571 | 0.142857143 |
Scent | 0.214285714 | 0.714285714 | 0.928571429 |
Layout | 0.142857143 | 0.785714286 | 0.928571429 |
Amenities (towels, water, ear buds) | 0.142857143 | 0.785714286 | 0.928571429 |
Size | 0.857142857 | 0.857142857 | |
Lighting | 0.071428571 | 0.928571429 | 1 |
Flooring | 0.071428571 | 0.928571429 | 1 |
Cleanliness | 1 | 1 | |
Total | 0.089285714 | 0.758928571 | 0.848214286 |
- Edited by tony bonn 2 Friday, March 13, 2015 4:30 PM