Hi all.

New to pivot tables so I do not know if this can be done. I have a
table that give the total amt. of all sales order for a contract. I
want to write a formula that places the contract total on each sales
order row. I can't seem to get it to work. Do I use getpivottabledata
or would a dsum work?

B.....


--
bsfacf