XL2007: Pivot table layout

[FrankParisi]

Hi

In my data, I have:
1. Age (up to 20, 21-30, 31-40)
2. Gender (male, female)
3. Location (London, Paris, Berlin)

I want to see Age and Gender as column labels and Location as row labels.
However, I don't want Gender as a sub-set of Age - I want Age Labels followed immediately by Gender labels ie:

Upto20 / 21-30 / 31-40 / Male / Female

I don't want: 21-30 Male / 21-30 Female / 21-30 Total / etc etc..

Is there a way to specify this in a pivot table?
many thanks for any help
Frank

 

[Andrew Poulsom]

Sorry no. You could use the Page field for one of them.

 

[FrankParisi]

Thanks Andrew
How do I find this Page function?
F

 

[Andrew Poulsom]

In Excel 2007 it's called Report Filter.