Pivot table refresh
I have a pivot table that includes all the sales data for two brands, by
region, and sales person. The data in the query table comes from a query of an oracle database. Now that we agree we'd like to keep this project moving, we are trying to limit the data in the query so we can disburse the information to gain additional feedback. My problem is that when I change the query to exclude certain markets or brands, I can still see those markets or brands in the drow downs in the pivot table. This is strange, because these markets/brands are now excluded from the query data and the pivot table has been refreshed. Is there any way to fix this issue? I'd like the pivot table drop downs to only include the items in our query data. |
There are instructions here for clearing old items from a PivotTable
dropdown list: http://www.contextures.com/xlPivot04.html Excel GuRu wrote: I have a pivot table that includes all the sales data for two brands, by region, and sales person. The data in the query table comes from a query of an oracle database. Now that we agree we'd like to keep this project moving, we are trying to limit the data in the query so we can disburse the information to gain additional feedback. My problem is that when I change the query to exclude certain markets or brands, I can still see those markets or brands in the drow downs in the pivot table. This is strange, because these markets/brands are now excluded from the query data and the pivot table has been refreshed. Is there any way to fix this issue? I'd like the pivot table drop downs to only include the items in our query data. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thank you Debra, I had just stumbled upon your website.
"Debra Dalgleish" wrote: There are instructions here for clearing old items from a PivotTable dropdown list: http://www.contextures.com/xlPivot04.html Excel GuRu wrote: I have a pivot table that includes all the sales data for two brands, by region, and sales person. The data in the query table comes from a query of an oracle database. Now that we agree we'd like to keep this project moving, we are trying to limit the data in the query so we can disburse the information to gain additional feedback. My problem is that when I change the query to exclude certain markets or brands, I can still see those markets or brands in the drow downs in the pivot table. This is strange, because these markets/brands are now excluded from the query data and the pivot table has been refreshed. Is there any way to fix this issue? I'd like the pivot table drop downs to only include the items in our query data. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 09:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com