Pivot Table for Inventory Database

I have an inventory database that has separate fields for receipts and
dispersements. How can I make a pivot table to show the part numbers, the
receipts and dispersements and a running balance?
tia

Have a look at the PivotTable info on Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

Scroll down to "P" section.


Gord Dibben Excel MVP

On Tue, 22 Mar 2005 19:54:19 -0500, "ridgerunner" <&il_utrll@msn.com> wrote:

>I have an inventory database that has separate fields for receipts and
>dispersements. How can I make a pivot table to show the part numbers, the
>receipts and dispersements and a running balance?
>tia
>
>

Thanks! I will check this out.

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:j2h141ddsge9tm4oppf7c9mdmpcpod6kjk@4ax.com...
> Have a look at the PivotTable info on Debra Dalgleish's site.
>
> http://www.contextures.on.ca/tiptech.html
>
> Scroll down to "P" section.
>
>
> Gord Dibben Excel MVP
>
> On Tue, 22 Mar 2005 19:54:19 -0500, "ridgerunner" <&il_utrll@msn.com>
> wrote:
>
>>I have an inventory database that has separate fields for receipts and
>>dispersements. How can I make a pivot table to show the part numbers, the
>>receipts and dispersements and a running balance?
>>tia
>>
>>
>