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 |
Pivot Table Question
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 "John Calder" wrote: 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 |
Pivot Table Question
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 |
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 |
All times are GMT +1. The time now is 04:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com