View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Pockmire
 
Posts: n/a
Default Pivotable Sum of Cost times Quantity

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?