Hello @aleksandra_budnik,
I feel like the point I am trying to make is being over looked, as I was trying to provide a simple example of the issue I have encountered. So I’ll try to explain it a bit better using this data:
[11, 12, 13, 14], [21, 22, 23, 24], [11, 22, 23, 24], [31, 32, 33, 34], [41, 42, 43, 44], [11, 52, 43, 34]
In Column A I decide to filter out 11 by whatever means:
- Filter by value - 11
- is not equal to 11 (The one I used for this example)
- greater than 12
It doesn’t matter which way the table then becomes
[21, 22, 23, 24], [31, 32, 33, 34], [41, 42, 43, 44]
Then I decide to use filter by value in Column B, it does not matter what I chose as long as it is filter by value so for an example I’ll uncheck both 22 and 32 out the 3 presented options of (22, 32, 42).
This now makes the table:
[41, 42, 43, 44]
Now if I decide to change the filter in Column A, the response I would expect is not displayed,
so for this example I will change the filter by condition to none.
the returned table looks like this:
[41, 42, 43, 44]
However, the only filter left that I have implemented was in Column B which was filter by value 22 and 32, yet when I now open Column B, 12, 22, 32, & 52 are all unchecked.
12 and 52 automatically became unchecked because they were removed from the table from the first query. I never wanted to remove 12 & 52 but they just happened to be removed by querying 11 out of Column A. It makes sense to me that the table should look like this upon reverting the Column A filter:
[11, 12, 13, 14], [41, 42, 43, 44], [11, 52, 43, 34]
but based on how it works now looks like this:
[41, 42, 43, 44]
My original question was to find if there was a way around this, if this is a known issue, or if I am just missing something.
Thank you