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.
Bookmarks