Filter a table box based on a key field

[#1]

I am attaching a quick example similar to what I am trying to do.

I have calls with a CallID.  There may be 1 or many lines for a call. Calls have segments (# order) and categories.

If I filter on a certain category, the chart in the attached example works as expected.  I only see the line with that category.

However, what I want to see is all the lines for call where the category exists on any line.  For example, I have one call that was conferenced.  It is CallId 11111.  If I click "Conference" in the categories, I see that one line from that one call in the "Works" chart as expected.  What I want to do is build a table box that shows all 3 lines for the call.

Is this possible?

Thanks!!!

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

CallID

Category

Expression

=Only({1<CallID = P({1<Category={$(=GetFieldSelections(Category))}>} CallID)>} Segment)

[#3]

Thank you so much!  Worked perfectly.  I really appreciate it.

[MK_QSL]

Kindly close the thread by selecting appropriate answer.