Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
pivot table - keep text wrapped on refresh? | Excel Worksheet Functions | |||
Pivot Table Refresh Problems | Excel Discussion (Misc queries) | |||
Pivot Table Data Refresh | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |