Duplicating row labels in a Pivot Table - Excel 2011

Hello All,

So I have a pivot table with two row labels (Zone and Ads) and two value parameters in my pivot table.

My issue is I would like the pivot table to make my first row label (zone) duplicate for every (ad - second row label) so I do not have to cut and paste it when I transfer the pivot table information elsewhere.

I have tried changing the layout to tabular (as it is now) and changing the print settings to duplicate row labels on each page but have not gotten my pivot table to duplicate that first zone labels for every ad associated with it.

I have attached the doc to this thread. I am working on a Mac. Any help will be greatly appreciated!

Thanks,

M

under field setting

on the Layout & print

check the "Repeat Item Labels"

is that what you are looking for?

your picture didn't come through....I don't see in the file that you have duplicated the row labels...I'm attaching the file I did....

exactly how I said in post #2....I'm not sure what is different...you do need to make sure you are right clicking in any of the Zones Cells....I take it that worked?

right click on choose

"Field Settings"...
Layout & Print

I take it that worked....sweeeeeet

Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...