If both actions are filtering the same field and going to the same sheet, they're going to conflict.
Make two sheets. Just do Copy Sheet and make a new copy. Have one action control one sheet, and the other action control the other. And then you can use "leave the filter" on each one so that they clear away under the appropriate conditions.
Appreciate the response, Joe.
Creating two sheets is the workaround what I was thinking as well but want to avoid that. I don't know if there is any other workaround without duplicating the sheet but I'll try creating a second sheet.
Hi Maneesh Are you looking like below
this is hover
What you need to do is duplicate the category field pass the hover action on original field and select action on duplicated Category Field
Hope this helps
Plz mark this answer as correct or helpful to close the thread
Thanks a lot, Naveen. This worked
EDIT: This works partially. When I want to make a different Category selection and before clicking on the second category, hovering on it makes the Target sheet go blank because we are inputting different selections through different actions