I have 2 report filters in pivot table (state & city).When i filter by state ,i get all cities in 2nd report filter.but i need the cities in that state only to be displayed in the 2nd report filter.I tried vba as that has to be solution.but couldnt get thro...kindly help me ...its urgent