Linked list in filters - part 2
First of all, thank you very much for implementing my previous request with Auto Filters! I really appreciate it!
I'd like to open the second part of my previous request and add something new :)
Suggestion 1. If I use a parent list in the criterion, the criterion of a linked list should show me only the values that are related to the parent list value.
For example, I have two fields
Feature - values A, B
Sub Feature - values (A) 1,2 ; (B) 3,4
If my first criterion is "Feature is A", and I start to create criteria "Sub Feature is..", then the dropdown list should show me only values 1,2. Currently it shows 1,2,3,4
Suggestion 2. Same thing but in separate filters:
If I use a parent list in the criterion of one Filter, and the criterion of a linked list in its Sub Filter, this criterion should show me only the values that are related to the parent list value.
For example, I have two Filters
Filter X with criterion: "Feature - values A, B"
Filter Y (sub filter of X) with criterion: "Sub Feature - values (A) 1,2 ; (B) 3,4"
If the criterion of my first filter is "Feature is A", and I start to create criteria of its Sub Filter "Sub Feature is..", then the dropdown list should show me only values 1,2. Currently it shows 1,2,3,4
Thank you in advance!