View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Pivot Table Question

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