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