Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display repeating data in Pivot Tab
Hello,
I have a Pivot Table which displays 3 fields. By defaults, Excel groups the data and removes the repeating data. For example, I have the following: CustId Account# Balance 1 A1 200 1 A2 300 2 A3 400 Excel displays this as, CustId Account# Balance 1 A1 200 A2 300 2 A3 400 Note that it doesn't display CustId in the 2nd row. But I want it to display it. How can I do this? Thanks Vasan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display repeating data in Pivot Tab
Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells: http://www.contextures.com/xlDataEntry02.html Fill Blank Cells Fill Blank Cells Programmatically -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vasan" wrote in message ... Hello, I have a Pivot Table which displays 3 fields. By defaults, Excel groups the data and removes the repeating data. For example, I have the following: CustId Account# Balance 1 A1 200 1 A2 300 2 A3 400 Excel displays this as, CustId Account# Balance 1 A1 200 A2 300 2 A3 400 Note that it doesn't display CustId in the 2nd row. But I want it to display it. How can I do this? Thanks Vasan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display repeating data in Pivot Tab
But this won't work if it's still a pivottable.
The OP can either copy|paste special|values first, then do this. Or copy to a new worksheet (as values). Then do it against that sheet. Max wrote: Try Debra Dalgleish's page for some nice ideas on filling in the blank cells: http://www.contextures.com/xlDataEntry02.html Fill Blank Cells Fill Blank Cells Programmatically -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vasan" wrote in message ... Hello, I have a Pivot Table which displays 3 fields. By defaults, Excel groups the data and removes the repeating data. For example, I have the following: CustId Account# Balance 1 A1 200 1 A2 300 2 A3 400 Excel displays this as, CustId Account# Balance 1 A1 200 A2 300 2 A3 400 Note that it doesn't display CustId in the 2nd row. But I want it to display it. How can I do this? Thanks Vasan -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display repeating data in Pivot Tab
"Dave Peterson" wrote
But this won't work if it's still a pivottable. Thanks. Yes, I missed that point in the OP. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
create one pivot from mulitple data sources | Excel Discussion (Misc queries) |