Hello,
I am using a pivot table to figure costings for construction. I have the following two columns:
Item, Unit Cost
What I would like to do is be able to add in an additional Quantity column and be able to modify this value on the fly so that I can calculate the total cost without modifying the original table. The Pivot table would look something like this:
Item, Unit Cost, Quantity, Total
where Total = Unit Cost * Quantity.
Whenever I try to modify a value in the Quantity cell it tells me take I can't perform that operation. Is there any possible way to accomplish this? Would this require programming in VB? If so, can someone please point me in the right direction?
Thank you,
-Travis
Bookmarks