I have now been playing with pivot table for a week and have virtually got it exactly how i want it.

If only I had learned about PT's years ago!!

One thing I am unable to do is to have a value field in between 2 Row fields.

ie my columns are

Venue - Capacity - Next Date - Note - and Max of Date 4 x Row Field and 1 Value Field

The Max of date obviously returns the last date played at a particular gig.

However, I want this column to be after the Capacity Column and the Next Date and Note to be at the end of the row like this

Venue - Capacity - Max of Date - Next Date - Note 2

That is 2 x Row Field - 1 Value Field - 2 x Row Field

Can this be achieved.

Many thanks Rob