how to count rows in grid that are in the same group:
for example i have a grid with column items 'male' and 'female' and i need to count how many males and females is there in my grid so that i can show it's ratio in pie chart
i grouped my grid by 'gender' field but i dont know how to get the numbers to show in chart