Repeat Row name in Pivot Table

[arnorian]

Hi

I have a Pivot table with two row variable; SKU (priamry) and Customer Name (secondary). What I need is for the SKU name to appear for every customer (I have some other formulas that are drawing from SKU name). I hope this makes sense. I have tried to add it into columns but names dont appear since Pivot thinks its value and just gives me a 'count' of my customers.

Currently:
COLUMN 1
[TABLE="width: 216"]
<colgroup><col></colgroup><tbody>[TR]
[TD]SKU 123[/TD]
[/TR]
[TR]
[TD] Customer 1
Customer 2
Customer 3
SKU 234
Customer 1
Customer 5
Customer 7[/TD]
[/TR]
</tbody>[/TABLE]


How I need it to look
COLUMN 1 Column 2
SKU123 Customer 1
SKU123 Customer 2
SKU123 Customer 3

SKU234 Customer 1
SKU234 Customer 5
SKU234 Customer 7

 

[sheetspread]

Design--Report Layout--Repeat All Item Labels (and switch out of compact form)

 

[arnorian]

Perfect. Worked like a charm. Thank you