SSRS - How to do this sort of pivot?

I have following data when I get totals for area, group based on the open close items. The data needs to be reported as a pivot table. Area, groupnames are parameter filters , if they select just grpB, grpA should not be displayed in pivot table. I am not sure how this could be achieved. Can you please give me pointers how to resolve this?

area_name group_nameQuarter openclosed all

---------------------------------------------------------------

xx grpA 1 2 35

xx grpB 1 4 26

yy grpA 1 1 12

yy grpb 1 2 13

zz grpA 1 3 14

zz grpb 1 1 12



xx grpA 2 2 24

xx grpB 2 4 15

yy grpA 2 1 12

yy grpb 2 1 12

zz grpA 2 2 24

zz grpb 2 3 15











area_name QuartergrpA grpBtotal

open closeopen close

---------------------------------------------------------------------------





xx 1 23 4 2 11

yy 1 11 2 1 4

zz 1 31 1 1 6

---------------------------------------------------------------------

grand totals 16 4 7 4 21





xx 2 22 4 1 9

yy 2 11 1 1 4

zz 2 22 3 1 8

---------------------------------------------------------------------

grand totals 25 5 8 3 21