Good evening.

I will use a simple example of what i'm trying to achieve because my english are not so good.

Let's say we have a pivot table with 3 rows and 3 columns

Total 8 5

. D E
A 5 1
B 2 2
C 1 2

I created a calculated field which divides D by E

Total 8 5 8/5=1.6

. D E F
A 5 1 5/1=5
B 2 2 2/2=1
C 1 2 1/2=0.5

My problem is that I need the total row of the calculated field not to divide the sum of D by the sum of E,
but to sum the F column (the result in this example will be 6.5 not 1.6).

Is it possible?

I'm sorry for my bad example.

I thank you all in advance.