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"