how to show repeating data in pivot table (not grouped)
 

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.

how to show repeating data in pivot table (not grouped)
 

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

how to show repeating data in pivot table (not grouped)
 

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