Thread: getpivotdata custom subtotal cell reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default getpivotdata custom subtotal cell reference
Change the first argument from $B$15 to $B$15&""
See:
http://www.contextures.com
Excel -- Pivot Tables -- GetPivotData
Using Cell References For the Data Field in GetPivotData

Reply With QuoteReply With Quote