Thanks Dave - worked a treat!
"Dave Peterson" wrote:
Not possible to do this and keep it a pivottable.
I copy the pivottable to a new worksheet and paste|special values. That copy is
no longer a pivottable, but I can do anything I want to the data.
Including following these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html
NKA wrote:
Hi all,
I have searched through every possible option (or so I think) but cannot
find anywhere. I am trying to pivot data but then show all repeating data in
the pivot table. Does anyone know how to do this?
Difficult to explain. Where a field is grouped as there are multiple
results - I want to see the field info for each line.
--
Dave Peterson