Show count based on group

hi team,

i have report requirement need show count based on groups.

see below table data , expected report:

appreciate inputs

regards,

---

please don't forget marked answer if post solved problem , use vote helpful if post useful. helpful other users.

hi eswararao,

create report table having 2 groups

parent group -  group on interfacename shown in below screen:-

add child group 2 columns interfacename , activestatus column hsown in below screen:-

delete detail default group , report design below:-

run report ,

thanks

prasad

SQL Server  >  SQL Server Reporting Services, Power View