View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sonya
 
Posts: n/a
Default How do I repeat labels in Excel for a pivot table field?

I can't figure out how to show a label on a pivot table without hiding
duplicates. For example, instead of the standard pivot summary:

Part Number Work Center Qty
ABC 1 20
2 35
XYZ 5 40
8 20
I want to see it like this with all information shown (nothing compressed):
ABC 1 20
ABC 2 20
XYZ 5 40
XYZ 8 20