I am using the Builder to create a table. In my source file I have single year ages but in my end table I want 5 year age groups. I have been building the table with the single year ages and then creating the total age groups I want. Since I don't want single year of age in my table I have to delete them. But now I have to remove all my total groups in order to do this. Is there an easier way of doing this?

Yes, there is an easier way.

First, create a new Dimension Definition file with two fields, [code] and [AgeGroups] as an example. List the single year ages in [code] and their desired age groups in [AgeGroups], like this:

[code] [AgeGroups]
0       0-4
1       0-4
2       0-4
3       0-4
4       0-4
5       5-9
6       5-9
7       5-9
8       5-9
9       5-9
etc..

When creating your table, define your source fields as usual, and then define a redefinition field ( Source > Define Redefinition Fields), Call it AgeGroups, load the previously defined Dimension Definition file, Select [Age] as a source field, match it to the [code] lookup field, and selecr [AgeGroups] as the value field. Use the new dimension [AgeGroups] instead of [Age] in your table design.