| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a Pivot Table from Dbase that is Grouped? | Charts and Charting in Excel | |||
| Format a Grouped Date in a Pivot Table | Excel Worksheet Functions | |||
| Pivot table grouped results | Excel Worksheet Functions | |||
| Repeating data in a Pivot table | Excel Worksheet Functions | |||
| Pivot table-show all grouped items | Excel Discussion (Misc queries) | |||
Linear Mode
