View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Subtotal based on a range of data in Pivot Table

Excel 2007 Pivot Table
Odd grouping and text values easily done.
http://www.mediafire.com/file/jzunxyudviw/09_24_09.xlsx
Excel 2003 aid included.