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.
 
Back
Top