I have created a Pivot Table from a spreadsheet - which has monthly values for five years. So that's 60 columns of monthly "numerical" data
plus four other - "text" fields.
Now as users of Excel 2003 are aware - as soon as a new Pivot Table is created - a Pivot Table Field list "task pane" appears besides the
pivot table.
While the feature is good in the sense you can drag and drop any field covered within the range of the pivot table without having to go back to the original layout of the pivot table (as in older versions of Excel). However it seems to me that you can only select one field at a time when using this
feature.
At present my current Pivot Table has only "one" monthly "numberical" column in the "DATA" area of the Pivot Table - Can anyone suggest a quicker way of updating the Pivot table so that more then one or in the case of this example (59 columns) of data can also added to the "DATA" area in one without having to drag each month individually and "drop" it into the Pivot Table ?
plus four other - "text" fields.
Now as users of Excel 2003 are aware - as soon as a new Pivot Table is created - a Pivot Table Field list "task pane" appears besides the
pivot table.
While the feature is good in the sense you can drag and drop any field covered within the range of the pivot table without having to go back to the original layout of the pivot table (as in older versions of Excel). However it seems to me that you can only select one field at a time when using this
feature.
At present my current Pivot Table has only "one" monthly "numberical" column in the "DATA" area of the Pivot Table - Can anyone suggest a quicker way of updating the Pivot table so that more then one or in the case of this example (59 columns) of data can also added to the "DATA" area in one without having to drag each month individually and "drop" it into the Pivot Table ?