Group by multiple columns/group by calculation

[burghard]

First I want a list to be automatically grouped by multiple columns without the possibility to expand. One group value must not be a column but a value, which is calculated from a column.

The table lists personal records and should be grouped by the year of birth (calculated from the column date of birth) and sex (male or female).

Is this possible? I already created a SQL view, but cannot show lists which have an underlying SQL view.

 

[burghard]

Ah! it is not necessary for the list to be expandable collapsable. It should only display the grouped sums or counts.