Pivot Table lists

[Steve]

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"

 

[Max]

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

 

[Suleman Peerzade]

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]

Base Item Roll Lot Current Net Balance Total
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

 

[Steve]

Thanks Max. I believe that will work just fine.
Steve

 

[Max]

That's good, Steve. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik