Looks ok, try this thread: http://tinyurl.com/bp64n
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"baabaa" wrote in message
...
Can we use the "if" function in a calculated field of a pivot table?