[5分]如何在报表中实现双指标分组统计

无法上传附件，以下代码也一样

TRANSFORM Count(各人资料.年龄) AS 年龄之Count
SELECT 各人资料.籍贯, Count(各人资料.年龄) AS 合计
FROM 各人资料
GROUP BY 各人资料.籍贯
PIVOT IIf([年龄]<18,"少年",IIf([年龄]>=18 And [年龄]<36,"青年",IIf([年龄]>=36 And [年龄]<61,"中年","老年")))
WITH OWNERACCESS OPTION;