I have a pivot table with 3 dimensions ;Department, Task and Description
I need to sort by a specific field , ORDER, which is not one of them.
The only way it works so far is if I make ORDER the second dimension and sort numerically. This is not going to work in visual terms though
1) Choosing custom sort for each dimension and putting ORDER in the expression for Task
2) Choosing custom sort putting DUAL(DEPARTMENT,ORDER) in the expression for Department
3) Adding ORDER as the second dimension and hiding it with Show Column if 1=2 and sorting on this column
None of these work
Any suggestions.
