@Mikhail
I am trying to do something similar to the above problem you laid out but for some reason was not able to get it to work. Wondering if you could help me on where I am messing up. I have laid out screen shots of what I am doing and what I am trying to accomplish.
1. I have a dataset with all the values. What I am trying to do is create three dependent filters. So ultimately when I select a service only certain values show up for Inverter Type and when I select an inverter type only specific values show up for supplier name.
2. For the first list “Service” I created another data set with just the specified values “Replace a Solar Panel” and “Replace and Inverter”
3. Then on the page I created two drop down list to begin with.
4. Here is the way I linked them. They are both linked back to a “ContactUs” Data base because when they submit I want the values select to push back to another data base so I can keep and utilize the data for my CRM system.
5. I connected the second drop down.
6. Then I did a filter on Dataset2 for services.
This did not seem to work and after that I was lost on how to filter the third data set “Manufacturers” on both the first and the second data sets.
Any help would be greatly appreciated!
Thank you,
-Dylan