PivotTable
 

I have a pivot table with 2 row fields. (For example, i have RowField1 and
RowField2 in this order. Let's say RowField1 has 2 items: USA and Europe.
RowField2 has LA, SFO, NY under item USA of RowField1 and Paris, London
under Europe.)

I want to be able to list for each item in Rowfield1, all items in Rowfield2
that is under it? Like

USA
LA
SFO
NY
Europe
Paris
London

I tried to use PivotItems but it lists all items in all fields.

I also tried to use childitems but it returns nothing. I really dont
understand fully the concept of childitems and childfield. I mean what's the
heirarchy order?

need help. thanks

\0\0\0\0\0