Does anyone know a way to show duplicate values in an excel pivot table (i dont want to copy the values out and run formulas to fill in the blank rows). The default behavior seems to be to suppress duplicate values when grouping by a row label...I want to show them.
Let me know if you need a screenshot of what I am talking about.
Thanks!