Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a column to "auto fill" in a pivot table?
Hi, I have a pivot table that consists of a store number and vendor name in the row. The total dollar amount is in the data. There are are more vendor names than store numbers. When I run the pivot it gives me the store number once and the fills in all the vendor names with the dollar amount. Example: Store Vendor2 Amount 2 a 1 b 2 c 3 d 4 I would like the Store # to be repeated. Any ideas? Thanks, Eddie -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=491967 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a column to "auto fill" in a pivot table?
My example didn't work out too well. Sorry. Here is what it comes down. I have about 250 stores that I run pivots on from time to time. When I take it out of the pivot format I don't want to have to go back and drag or copy and paste all the missing data for the stores column. Thanks -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=491967 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a column to "auto fill" in a pivot table?
If you're willing to lose the pivottable (make a copy of it???), you can do
something--but if you want to keep it a pivottable, then excel won't let you change this. I either convert the pivottable to values (or make a copy and convert that one to values). And since it's just values, I can do anything I want. (I do try to clean up as much formatting as I can while it's still a pivottable, though.) Debra Dalgleish has some techniques for filling those empty cells with the value from the cell above: http://www.contextures.com/xlDataEntry02.html punter wrote: Hi, I have a pivot table that consists of a store number and vendor name in the row. The total dollar amount is in the data. There are are more vendor names than store numbers. When I run the pivot it gives me the store number once and the fills in all the vendor names with the dollar amount. Example: Store Vendor2 Amount 2 a 1 b 2 c 3 d 4 I would like the Store # to be repeated. Any ideas? Thanks, Eddie -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=491967 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
refresh of pivot table clears fields (column headers) | Excel Discussion (Misc queries) | |||
Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions |