If I have 4 fields in the rows and 2 fields in the columns... how pull the
data so that the fields in the rows are repeated?

For example: if I have a table with country, state & city and I wanted to
see WA repeated for every city in WA... is there a way to do that in the
Pivot table?

Thanks!