 |
 |
> this is very interesting, > and i had not seen it, > BUT > i tried it and it seems that it allows us to do the summary operation > on calculated field instead of the original data files. > so it would allow us to calculate us the sum of squares for a data > column for each group > without defining an extra columns for the squares. > > as far as i see, thois does not allow us > to calculate the median of group of values. > this would need an additional summarizing operation, > not an operation applied to each single value of the data. unfortunately, calculated fields are not something very useful. They only effecutate the calculations on the items of the resulting pivot table. Not at all on the value in the initial data table. This implies that the calculation in calculated fields should be linear, else you will have troubles: if you have Subtotals (usually Sum) then the calculated field will display the Calculation on the sum of the items, which is not the same as the Sum of the Calculation on every item. For example, take a calculated field which takes the minimum of 2 other fields. Further, you can't use calculated fields if one of your pivot field is grouped. François Sermier %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%