Hi all,

Wonder if you could help, on my report I have a distinct count of the Employee_No fields on a group field. On the same field though I need to also display the distinct no of employees by their age group. like in the example below. I have came to conclusion it needs to be done in a formula but having a little trouble with writing it, it's probably something dead simple. Any questions just ask. Thanks

Total Number     Age group      Age group     Age group
of Employees:      <30:        30-50:        50+
    90               20            55           15