Hi everyone!
Could you please help me to solve the following problem:
I have a table like this:
data = {
'Level 1': ['A', 'A', 'B', 'B', 'C', 'C'],
'Level 2': ['X', 'Y', 'X', 'Y', 'X', 'Y'],
'Level 3': ['1', '2', '1', '2', '1', '2'],
'Car ': ['Car 1', 'Car 2', 'Car 3', 'Car 4', 'Car 5', 'Car 6'],
'Amount': [10, 20, 30, 40, 50, 60]
}
Iβd like to add 3 multiselect boxes to sidebar (options to choose values in Level 1, Level 2, Level 3) so that if something checked in any box or boxes, values in the other boxes should be also filterd accordingly.
The main problem is that nobody knows what filter will be used first. For example, someone can choose 1 in Level 3, so in the filter level 2 values should be X, for Level 1, A, B,C. Someone can start from Level 2 and so on.
Hope you can give me some ideas how to do it, thank you very much!