Thread: Pivot table formulas based on text fields
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pivot table formulas based on text fields
Add two columns to the source data:
=--(date0)
=1
and divide them in a Calculated Field.
Too time consuming?
Reply With QuoteReply With Quote