SELECT MEASURES.[%COUNT] ON 0,
NONEMPTYCROSSJOIN(diagd.MEMBERS, aged.[age group].MEMBERS) ON 1 FROM patients
Patient Count
1 None->0 to 29 363
2 None->30 to 59 348
3 None->60+ 120
4 asthma->0 to 29 36
5 asthma->30 to 59 37
6 asthma->60+ 11
7 CHD->30 to 59 13
8 CHD->60+ 23
9 diabetes->0 to 29 1
10 diabetes->30 to 59 20
11 diabetes->60+ 25
12 osteoporosis->60+ 22