crosstab report with clients status

[abdunnasirkp]

Hi,

 

I have a table with structure as shown below

id, name, status (Active / Inactive), age

I would like to generate a crosstab report as shown below

 

Total Clients: 300

Active Clients: 100

Inactive Clients: 200

Clients with age < 30: 200

Client with age > 30: 100

How can we generate such a report?

 

I tried to create such a report, but didn't work for me. Please help.