Custom Sorting in a Pivot Table

[clarcombe]

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.