Hi,
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.
Thanks
EP
How can I do?