Generating specific tables from dropdown

Hi. This is my first post. :slight_smile:

I’ve been loving Dash and it’s really fun to work with.

I’m currently facing an issue.
In my app, I want to generate a table from the dropdown options with an excel sheet as a data source (it’s a pivot table).

Each dropdown option has a sub category.

For example, Dan has fiction, self help, sports and business books with him while Sarah has poetry, fiction and autobiographies with her.
The pivot table in Excel has person by his/her name and each category of books with their quantities as shown

How do I modify my dropdown in such a way that it shows the table for only a particular person?

For example, if Emma is selected from dropdown, it should display only this:

Thank you! Help would be appreciated.