google visualization piecharts

[Harsha Vardhan]

hai to all

   i have two category filter controls one for gender and other for teams  and i have four piecharts such that first piechart should show the aggregation of gender for all the teams, second piechart should show the aggregation of gender for first team and second chart shows aggregation of gender for second team and so are the remaining charts. all the charts are rendering fine but the problem is when i select team1 from the category filter all the four charts are showing the aggregation of gender for team1, that should not happen.

for this iam taking the source from google spreadsheet. Does anyone have any idea.