Thread: Pivot table and variance calculation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pivot table and variance calculation
Excel 2007 PivotTable
Do calculations in PT, not source data.
Two examples, two source styles.
http://www.mediafire.com/file/dy0yn2jme2j/02_01_10.xlsx
Reply With QuoteReply With Quote