In Agile Central, I'm not aware of out-of-the-box functionality that allows you to filter on values from any of the child elements. i.e: Starting from Capabilities, filtering on a Feature or User Story attribute.
But in spreadsheets, you can do anything.
For example, there's a really cool community app called "Custom List with Deep Export" that allows you to export your Portfolio Hierarchy, User Stories, and Tasks to a CSV file.
In the example below,
- I updated I configured the app to start from the parent of my features (Business Epics in my subscription).
- I exposed all the fields I need for reporting, including the Release column.
- Exported my Portfolio Items, Imported into my spreadsheet tool.
- Selected all my data, loaded it into a Pivot table.
- Pivot table settings: Rows: Business Epics, Name ; Columns: Release; Values: Count(a) Business Epics
If you use Google Sheets, you can export your Pivot table to an iFrame, and display it in Agile Central using the Custom HTML app.
Hope this helps.