Pivot Table Question

  • Thread starter Thread starter John Calder
  • Start date Start date
J

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
 
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
 
Hi John

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