Thread: Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB
Excel 2007 Pivot Table.
Calculated field, extended source data.
http://www.mediafire.com/file/1qyewt...07_06_09b.xlsx
Excel 2003 will not play this file,
nor be able to use the new 2007 features,
but you can probably glean the method from the pictures.
Reply With QuoteReply With Quote