Using formulas for pivot table

[tskb]

I know you have the count field but is there away to input a formula?
For example customer ordered 25 cases and each case weighs 4 lbs and
the end result would need to be total pounds ordered.
Thanks!

 

[Debra Dalgleish]

If you do the calculation in the pivot table you may not get the result
that you expect. If possible, add a field to the source data, and
calculate the order total there.
Then, add the OrderTotal field to the pivot table's data area.