Hey Kartik! 
@manyone’s solution on the Google Sheets end looks awesome, but since you mentioned trying out creating a local view in Thunkable and displaying that in your project, I thought I’d share a project that demonstrates this here.
As you can see, when a genre is selected from the List Viewer, I populate a local Data Source with items from my main Data Source that match this genre. Then I display the matching data in a Data Viewer.
I filter by one criterion, but you can easily modify this to filter by 2 or more criteria! Just add extra filter list and filter criteria fields as inputs to the show filtered data function, and link a few conditions together using and blocks in the if statement inside the function.
I’ll write a more detailed tutorial about this soon, since multiple Thunkers have asked about it, but I hope this demo project is helpful to you (or to someone reading)!