One way to do this is to create a calculated field, place it on a sheet, and use it as an action on a dashboard. The calculation would look similar to the following:
max([Sub-Category]) + ' (' +STR(sum([Number of Records])) + ')'
Hope this helps!
Thanks - Is there a way to do this without using a dashboard (as a quick filter)? I am not using dashboards or action currently and would like to avoid it.
You can also use that calculated field as a quick filter.
See an example attached, I created Calculation4 with the same logic, converting number of records into a string.
I added an if statement to be able to show only a top N of members in my dimension.
The Calculation4 (copy) was just added to exclude Null from my quickfilter.
Hope that helps
Dashboards and Actions are fun though, will give you a lot more functionality. Try it out