pivot table calculated field question

C

Cagdas Ozgenc

Greetings.

I have two questions:

1) I have a pivot table like the following

A B
Total
sum(T1) sum(T2) sum(T1) sum(T2) sum(T1)
sum(T2)

In this table I need to add sum(T1) / Total sum(T2) as a calculated
field. How do I do this?

2) I have a pivot table like the following

A B

runningtotal(T1) runningtotal(T2)
runningtotal(T1) runningtotal(T2)

I need to add runningtotal(T1)/runningtotalT2) (not
runningtotal(T1/T2)). How do I do this?

Thank you.
 
Top