Creating calculated dimension

[#1]

Hi

I have 3 tables with individual information, and I am trying to create a pie chart to show family status. The key fields are as folows:

ID = ID number of individuals

Role = Parent/Child

RegNo = Household Number

I am attempting to create pie charts with the following:

- Number of children in a household (Chart should show me Count(Distinct(RegNo)) with Age <=8 and Role = Child

I am currently using the code in Expressions

COUNT( {< Age = {">=0 <=15"}, Role = {Child}  >}DISTINCT(RegNo))

In Dimension, I am trying to get the pie chart to show "0 Children", "1 Child", "2 Children", ">2 Children", however I am unsure of how to proceed.

- Number of Members in a hosuehold

Expression: COUNT (DISTINCT ( RegNo))

Dimension: Should show "1 Member", "2 Members", "3 Members"....">5 Members"

Any advice will be greatly appreciated.

[#2]

Thank you very much