Filtering Tablebox for specific jobtitles

[#1]

So I have a tablebox i've created that has numerous different things in it including names, phone numbers and jobtitle.

If i want to have specific jobtitles only showing, not only if i click it, but at all times, how do i go about doing this?

I started with trying to make an matching expression within the title and an aggregate but im still not able to do this?

What im trying to say is that if i have for example: Server, Chef, Waiter i want my box to only (at all times) show the Waiters.

[jerem1234]

You can use a straight table and not tablebox.

Use set analysis like:

sum({<Job = {'Waiter'}>}Sales)

The set analysis should reduce your table to only show waiters

or if you want a calculated dimension, you can do something like:

aggr(only({<Job = {'Waiter'}>}Job), Job)

Then check suppress when value is null.

Hope this helps!

[#3]

Thank you!