Linked filter (ex : state and City linking)

I was trying create linked filter in dashboard,in my case i want to create filter for state and city in such a way that whenever particular state is selected,city filter should show only cities which come under that state i have tried many times in many ways to create filter like this but didn't work.

  1. Tried creating field filter and then linking it ,but didn't work
  2. Tried with seperate SQL query retrieve only cities by state filter but not able to achive linked result

Can anyone let me know how get desired results and how to create SQL query for this.

I have single table which contains state, city and some other column and state and city are category type.

So you create linked filters at dashboard level. I would recommend you go through this: