in a pivot table I have to divide all the possible values (val2) of a dimension (dim1) by the same amount (tot1, Header4) that is the total of the other possible values (val1) of the same dimension in order to obtain the incidence on the total (total1).
Header 2
Header 3
Header 4
Header 5
Header 6
Header 7
Header 8
Header 9
Header 10
dim1
val1
val1
tot1
val2
val2
tot2
incid
incid
dim2
20
30
50
15
35
50
15/50
35/50
dim2
10
15
25
10
25
35
10/25
25/25
tot
30
45
75
25
60
85
25/75
60/75
the possible values are defined as Sum(field)
In attached xls: blue columns are the "incidence"... yellow column is the total (denominator) and orange ones the numerator.
