Hi John

Inevitably, using helper columns in the source data gives far more
flexibility than using calculated fields.

--
Regards
Roger Govier

"John Calder" wrote in message
...
Hi

I have a table with 10 columns of data.

I have to create approximately another 8 colums that read this data and do
calculations from the 10 columns of data (I think you call them "helper"
colums)

What I would like to know is when creating a pivot table is it more
efficient to create helper columns or to add "calculated fields" to the
pivot
table instead.


Thanks

John