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 |
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 |
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 |
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 --- .. |
All times are GMT +1. The time now is 05:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com