View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default pivot tables custom formulas

You can't use User Defined Formulas in a pivot table calculation.

kvail wrote:
Can the PivotTable Field contain a user defined formula to summarize by...

For example: I want to have one field that provides the % of data points
that are equal to 4 or 5