Repeating data in a Pivot table
 

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!

Repeating data in a Pivot table
 

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill the blanks,
using the technique shown he

http://www.contextures.com/xlDataEntry02.html

Alicia wrote:
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?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html