Did you create your calculation using the Pivot TableFormulasCalculated
Field option? Sounds like the pivot table can't find the field names to
calculate from and so is giving you the ol' #N/A.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"joemeshuggah" wrote:

any ideas why i would get #n/a values down the column for a custom
calculation in a pivot table? column a shows the total amount of customers,
column b shows the number of customers that belong to a subset of column a,
and column c (custom calculation) is supposed to show the percentage that
column b is of a. when i attempt, i get #n/a values. what are the proper
steps?