I'm having a question about if this is possible or not do this kind of filtering, let me explain with an example.
I have this table:
And the columns January and February are set analysis expressions for those specific months:
My question is: Is there a way where I can click for example in cell where there is a value of 40 and a filter will be applied for both "BCS2" and month of January, for further data analysis in other objects?
I think not possible, you can make selections in dimension values only, measure cells don't allow selections. Its like selecting two dimensions in one go, which I think is not possible in native charts
Hi - your solution worked pretty good for me, except that I would like to be able to filter out the null values in the list and this is a problem as my code below, while populating the list with"Y", does not populate with "N" - can you assist?