What you need is to create a group by client type and then insert a cross-tab having rows = Age group, columns = Gender, detail = The function you want to apply.

Hope it works