Custom Grand Total in Pivot

[Bullsandbears123]

I am making a pivot table and I would like a custom grand total. But I'm not sure how to do it.

I would like to use =exp(sum(log(1+[field])))-1 instead of the standard sum of [field]

I don't know how to set it up, or if it is possible.

Does any one know?
THANKS

 

[markphsd]

Hey

This is a quetion to you. I have been having trouble with the pivottable rounding off the totals of my data. For example if a field value is 2.33 it rounds to 2.00. Have you experienced this, do you know of a solutions.

I haven't worked with custom fields much, but if I come across a solution I'll post it to this post.

Mark P.

Bleh