Below is my data, I loaded, will all of the fields are used to filter, in I chose 2021,09, kitchen electrical division, hutch defends electric, LKA after water, then choose humidifier, but the division, business unit also deselect, but my data inside is 2021, 09, hutch defends division, hutch defends electric data record, Shouldn't these satisfying field values be preserved?
Data:
load * inline [
Year, month, Business unit, Business Unit, Strategy Group, sub-category
2021,09, Kitchen and Bathroom Business Division, Kitchen and bathroom electric,LKA water purification, water purifier
2021,09, kitchen and bathroom business division, kitchen and bathroom household electricity, ring electricity, humidifier
2021,08, kitchen and sanitary department, kitchen and sanitary appliance, ring appliance, humidifier
2021,09, electrical business division, kitchen and bathroom,LKA water purification, vacuum machine
];