sql - SSRS Process data to get some percentages -

i have database entries organized in categories , subcategories. create report shows how many entries good/bad. need report organised in categories can expandable see subcategories result.

here picture of need:

can me suggestions how can achieve this?

thanks!

there 2 questions here.

percentage

you can use expression following work out:

=sum(iif(fields!flag.value = "true", 1, 0)) / countrows() 

i.e. number of true values in group / total group rows.

drilldown

you're looking drilldown functionality.

consider report this:

you can set drilldown row visibility bottom row:

here category name of textbox click show/hide row.

when report run can click on category textbox show or hide rows value.

unexpanded:

expanded: