Pivot Table drop down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In the page area, the pivot fields aren't dependent, and there's no
setting you can change to make them dependent.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list 2
Change drop down list in one cell based on values in other cells 2
% of subtotal in pivot table 1
About filter 7
Pivot Table - Show difference 6
Drop Down List 3
pivot table excel 2
Pivot table organizing 2

Back
Top