View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Pivot Table Question

Helper columns for me every time.

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

"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