I already tried this and there is nothing under the drop down box.
I'm sure i have calculated fields because they are not exist in pivot table
data.
How can i view them??

"Zhi Sheng" wrote:

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