View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Zhi Sheng Zhi Sheng is offline
external usenet poster
 
Posts: 13
Default Calculates field in pivot table

when you go to Formulas-- calculated field, you should be able to see your
own predefined fields in the drop down box (where you enter the name for new
calculated fields).
--
====================
ask and you shall be answered


"שרון" wrote:

Hi,

I can't find a way to view my calculated field in a pivot table.
I just need to see how they were defined (the formulas) because i want to
build a new pivot with the same fields.

I tried to go to Formulas-- calculated field but i can't see them!

Thanks