Pivot Chart - Multiple Page View - limit choices of 2nd view

[dsaye]

I'm trying to create a Pivot Chart (have created actually) that has two page views: 1) District and 2) Customer Name. I want a user to be able to choose their district and only the applicable customers related to their district show up in the list. Right now, all customers across all districts show up. Can this be done?

Thanks in advance.

 

[obiron]

The short answer is to set the visible property of the pivotitem to false for each customer that you DONT want to see.

The long answer is that is it pretty complicated. I have almost finished some code to do cascading page selections and I will post it when completed.

Obiron