Pivotable Sum of Cost times Quantity

J

Jim Pockmire

I have a calculated field in a pivotable that multiplies cost times quantity
to get an extended amount. However, when the pivotable computes the sum, it
first sums the quantities and costs and then does the multiplication -
yielding an incorrect answer.

What's the correct way to handle this?
 
Top