Hi, I created Bar chart in Tab1 and Stright and pivot tables in Tab2.
These charts having sum(Amounts), Ranges 1,2,3,4,5.
If i select a Range 1 in Barchart, in Tab2 straight and pivot table it shows sum(Amount) for Range1 is correct, along with that i want only Range1 column, but it displays all ranges. How to restrict other range columns, when i select on particular Range.
do to document properties then triggers and there you can select the dimension that you want from the field event triggers list box and then add action on the onSelect Trigger, form there add an action to activate sheet or move to next sheet etc...