Pivot table sorting results

[StephenSLR]

Is it possible to sort the results of a pivot table?

See attached file.

The 2.5 NB pipe is right down the bottom with the 24 inch pipe.

Also within the ranges, i.e. in the 4 inch range the 'schedule 80_' precedes 'schedule 40_'.

I can foresee that if it is possible to sort the 'schedule 120' will probably precede 'schedule 40_' is there a way of sorting that too?

s

 

[StephenSLR]

I figured it out and as predicted schedule 120 precedes schedule 40.

s