Pivot Table Question

[John Calder]

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

 

[Eduardo]

Hi,
In my experience I prefer to work with the helper and then select this field
in my Pivot Table, the reason is because always there is somebody asking for
something else and is easy to create that extra with the helper and then
populate it in the Pivot Table

 

[Roger Govier]

Hi John

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

 

[Ken Wright]

Helper columns for me every time.

Regards
Ken...............