Selecting one value to display data for other related values in a separate table

[#1]

Hello-

I have a question that will hopefully amount to a simple answer. I'm trying to allow users to select one name from a list of about 60 names that will allow them to see a table with data for each of the other names within the selected name's category. There are five categories. I've tried some set analysis and alternate state logic, but I can't quite figure it out. Anyone have any suggestions for me?

Thanks!

Nick

[maxgro]

hope to understand, see attachment

[#3]

Thank you! It wasn’t exactly the expression that I needed, but it certainly helped get me to where I wanted to be. Here’s what is working for me:

sum( {$<Name=, =P({$} )>} )

Thanks again!

Nick Fradkin

Manager, Chapter Reporting & Analysis

Make-A-Wish® America