How to order results in a pivot table?

[colgor]

In a pivot table one of my fields has a yes or no answer. The pivot table displays counts along the row in the order of No or Yes, when I'd prefer it in the order Yes or No. It does not seem possible to re-order within a pivot table. What is the best way around this please?

 

[Noodleski]

Not sure why you think it's impossible to sort in a pivot.
Simply click and hold the header of yes and drag it in front of the no-header.

If this doesn't work, could you please post an example of your source data, after removing any confidential content?

 

[colgor]

This did indeed work but I needed to be more careful when dragging. If not, in this example, it puts in a superfluous 'formula1' column that I cannot remove, Ctrl Z won't work either? I fund it difficult to post images in this forum.
Many thanks.