Thread: Pivot table formula with "show data as" value
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 formula with "show data as" value
Excel 2007
Best done with a dynamic auxiliary Table:
http://www.mediafire.com/file/mm2nimtycio/01_29_09.xlsm
Reply With QuoteReply With Quote