View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Pivot tables - calculations based on different sets of data

Excel 2007
Easily done inside the PivotTable,
with extended source data.
http://www.mediafire.com/file/ydzayy...07_08_09a.xlsx
Not so easy with Excel 2003.