How to execute group based subquery

Migrateduser

<p>herewith attached my expected result. i am new in birt report. i worked on group based query with drill down report. this working fine. but i want a report  group based result and count result also. </p>
<p> </p>
<p>Sample output</p>
<p><img src="https://i.imgsafe.org/711ba30629.png&quot; alt="711ba30629.png"></p>