View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott23 scott23 is offline
external usenet poster
 
Posts: 15
Default pivot table question

How can i use getpivotdata function if my pivot table has no row
field. I only use page , column , and data fields. However, i want
the use the data in the grand total of a certain data field which
happens to be a calculated field.
Thus there is no 'name' to reference since there is no row field ?

Thanks
scott