Add drill down feature to a table


Is there a way to add a drill-down feature to a table? I’m hoping to allow a user to click on a data point in a given column and information pertaining to another field of the dataset will show.

For example, let’s assume I have a dataset with the following fields: US states, US cities, car sales (total count), months. Now let’s assume I’ve created a table showing US states and their respective car sales for the month of October

Can I add a drill down feature where clicking on a particular US state will show the cities in that state (meaning, data is shown from a separate field in the dataset - namely, US cities), as well as the total car sales that each city has contributed in October?

Pivot Table Visualization can give you similar functionality Out of the Box.