Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table; adding kolomns to the base-table afterwards
Hi,
I have a MS Access database table (actually a query view on a table) I use this as data source for some pivots The problem: I have extended the query so it contains some extra fields, but those fields do not show in the PivotTable fields list. Does anyone know the trick? I have tried to refresh the data, saved and reloaded the excell, but this does not help. Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table; adding kolomns to the base-table afterwards
YOu need to redefine which fields the pivot table looks at. Bring up the
pivot table wizard and hit the Previous button to take you back to where Get Data was defined. Hit Get Data and select the new fields you want for your Pivot Table... -- HTH... Jim Thomlinson "overjaxed" wrote: Hi, I have a MS Access database table (actually a query view on a table) I use this as data source for some pivots The problem: I have extended the query so it contains some extra fields, but those fields do not show in the PivotTable fields list. Does anyone know the trick? I have tried to refresh the data, saved and reloaded the excell, but this does not help. Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table; adding kolomns to the base-table afterwards
You can redefine the source data range by right clicking one of the fields in
your table and selecting Pivot Table wizard. Then hit the back button and you can re-define the fields. If this doesn't help post back. overjaxed wrote: Hi, I have a MS Access database table (actually a query view on a table) I use this as data source for some pivots The problem: I have extended the query so it contains some extra fields, but those fields do not show in the PivotTable fields list. Does anyone know the trick? I have tried to refresh the data, saved and reloaded the excell, but this does not help. Thanks in advance! -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does anyone have an example data to base a Pivot Table on? | Excel Worksheet Functions | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
What happens if the data base changes; will the Pivot Table autom | Excel Discussion (Misc queries) | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
pivot table with dynamic base data | Charts and Charting in Excel |