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

N

NKA

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.
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove grouped items and fields from pivot table 1
Pivot Table Does Not Show Data 2
Pivot ungrouping on refresh? 3
Pivot table not recognizing same field values 1
Pivot Table and Grouping Problem 3
Group in Multiple Pivot table 1
repeating row group in pivot table 1
pivot table data 2

Top