Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table drop down
Dear All,
I have the following table: Business Unit Brand Razors A Razors B Razors C Blades X Blades Y Blades Z Im using this data (and a lot more) to create a pivot table. The fields: "Business Unit and Brand will be in the PAGE sectionof my pivot report. What im trying to do is: If i chose the business unit "Razor", then i only want to see products A, B and C in my drop down box for the field "Brand". I DONT want to show products X, Y and Z because they belong to other business unit. And If i chose the business unit "Blades", then i only want to see products X, Yand Z in my drop down box for the field "Brand". I DONT want to show products A, B and C because they belong to other business unit Hope you can help me Thx in advance Bhanji |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table drop down
In the page area, the pivot fields aren't dependent, and there's no
setting you can change to make them dependent. Bhanji wrote: Dear All, I have the following table: Business Unit Brand Razors A Razors B Razors C Blades X Blades Y Blades Z Im using this data (and a lot more) to create a pivot table. The fields: "Business Unit and Brand will be in the PAGE sectionof my pivot report. What im trying to do is: If i chose the business unit "Razor", then i only want to see products A, B and C in my drop down box for the field "Brand". I DONT want to show products X, Y and Z because they belong to other business unit. And If i chose the business unit "Blades", then i only want to see products X, Yand Z in my drop down box for the field "Brand". I DONT want to show products A, B and C because they belong to other business unit Hope you can help me Thx in advance Bhanji -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Drop down | Charts and Charting in Excel | |||
Pivot table drop downs | Excel Discussion (Misc queries) | |||
Pivot Table - Drop down choices | Excel Discussion (Misc queries) | |||
Sorting pivot table drop-down | Excel Discussion (Misc queries) | |||
Need help with Drop-Down list and Pivot Table | Excel Worksheet Functions |