| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table lists
Base Item Roll Lot Current Net Balance Total
713 141974 PLM981-21-A1.1 108.4 108.4 PLM981-21-B1.2 147 147 PLS015-21-A1 666.02 666.02 PLS016-23-B1 338.56 338.56 PLS015-21-B1.2 207 207 The above is part of a Pivot Table. Is there any way to fill in all the data so that "713" would be in all the rows under the title "Base" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table lists
Not within the live pivot itself, but you can easily extract it into adjacent
cols next to the pivot for your downstream purposes. Assuming the top 2 data cells "713" and "141974" of your pivot are in A5:B5 In F5: =A5 In F6: =IF(A6="",F5,A6) Copy F5:F6 to G5:G6. Then select F6:G6, fill all the way down to the penultimate row. That should populate it as desired. You can then point downstream formulas at the fully populated cols F & G. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Steve" wrote: Base Item Roll Lot Current Net Balance Total 713 141974 PLM981-21-A1.1 108.4 108.4 PLM981-21-B1.2 147 147 PLS015-21-A1 666.02 666.02 PLS016-23-B1 338.56 338.56 PLS015-21-B1.2 207 207 The above is part of a Pivot Table. Is there any way to fill in all the data so that "713" would be in all the rows under the title "Base" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table lists
Thanks Max. I believe that will work just fine.
Steve "Max" wrote: Not within the live pivot itself, but you can easily extract it into adjacent cols next to the pivot for your downstream purposes. Assuming the top 2 data cells "713" and "141974" of your pivot are in A5:B5 In F5: =A5 In F6: =IF(A6="",F5,A6) Copy F5:F6 to G5:G6. Then select F6:G6, fill all the way down to the penultimate row. That should populate it as desired. You can then point downstream formulas at the fully populated cols F & G. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Steve" wrote: Base Item Roll Lot Current Net Balance Total 713 141974 PLM981-21-A1.1 108.4 108.4 PLM981-21-B1.2 147 147 PLS015-21-A1 666.02 666.02 PLS016-23-B1 338.56 338.56 PLS015-21-B1.2 207 207 The above is part of a Pivot Table. Is there any way to fill in all the data so that "713" would be in all the rows under the title "Base" |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table lists
That's good, Steve. You're welcome.
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Steve" wrote in message ... Thanks Max. I believe that will work just fine. Steve |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table lists
Steve,
your table is refering to some data table where you need to copy this "713" under base, Remember to copy this in the specified table array of the pivot table and on the pivot table toolbar click the refresh button. The data will automically reflect in the pivot table. Or else you can try rearranging this data in the layout tab of the pivot table that should also work. Please get back if it doesnt work -- _______________________ Click "Yes" button if it helps ________ Thanks Suleman Peerzade "Steve" wrote: Base Item Roll Lot Current Net Balance Total 713 141974 PLM981-21-A1.1 108.4 108.4 PLM981-21-B1.2 147 147 PLS015-21-A1 666.02 666.02 PLS016-23-B1 338.56 338.56 PLS015-21-B1.2 207 207 The above is part of a Pivot Table. Is there any way to fill in all the data so that "713" would be in all the rows under the title "Base" |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table lists
Base Item Roll Lot Current Net Balance Total
713 141974 PLM981-21-A1.1 108.4 108.4 713 PLM981-21-B1.2 147 147 713 PLS015-21-A1 666.02 666.02 713 PLS016-23-B1 338.56 338.56 713 PLS015-21-B1.2 207 207 The problem that I have is in the Pivot table itself. The data table has the "base" designation in each row. I am trying to get the "Base" to show in each row of the Pivot Table as seen above. Thanks Steve "Suleman Peerzade" wrote: Steve, your table is refering to some data table where you need to copy this "713" under base, Remember to copy this in the specified table array of the pivot table and on the pivot table toolbar click the refresh button. The data will automically reflect in the pivot table. Or else you can try rearranging this data in the layout tab of the pivot table that should also work. Please get back if it doesnt work -- _______________________ Click "Yes" button if it helps ________ Thanks Suleman Peerzade "Steve" wrote: Base Item Roll Lot Current Net Balance Total 713 141974 PLM981-21-A1.1 108.4 108.4 PLM981-21-B1.2 147 147 PLS015-21-A1 666.02 666.02 PLS016-23-B1 338.56 338.56 PLS015-21-B1.2 207 207 The above is part of a Pivot Table. Is there any way to fill in all the data so that "713" would be in all the rows under the title "Base" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Combine 2 lists for source data | Charts and Charting in Excel | |||
| Pivot Table - Combine 2 lists for source data | Charts and Charting in Excel | |||
| Reorder pivot table field lists | Excel Discussion (Misc queries) | |||
| Pivot Table - Column Drop Down Lists... | Excel Discussion (Misc queries) | |||
| The Pivot Table Field Lists Do not Display | Excel Discussion (Misc queries) | |||
Hybrid Mode
