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.