And followed the same logic for developing other 3 dimensions
Which works fine when I wanted to see if any of the customers for all the years have at least once Negative, Positive or Zero Impact. Also all the filters work in combination with each other. However I did not wanted this functionality my intention was to create dimensions so that they work on aggregation of these measures across all the years by customers
Hence, I created calculated dimension as follows (to use in the filter pane) -
These calculated dimensions in a filter work fine when used individually, but do not work in conjunction (Initially applied filter is not being retained when I try to select a value from another Impact filter) with each other. My problem is I want to be able to mix and match these filters to derive further insights from the data.
For example - Let's say I want to filter customers who had negative impact in category 2 but positive impact on category 1 and negative in category 3. but I am not able to do it with aggr filters