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

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