Dimension with Set Analysis expression

[#1]

Hi folks,

I have a funnel chart where the dimension is a 'Status' and the expression is a count by ID using set analysis, like this:

=Count( {$< Status= {"AAAAAA", "BBBBBB", "CCCCCC"} > }  Id)

The chart is:

But... when I click in the blue colour on the chart, the chart is static...

All the dimensions around the sheet has changed... but the graph is the same.

I would like when I click on blue (represented by "AAAAAAA" status) the chart sould be:

How do I do that?

Thanks,

Rodrigo.

[johnw · Accepted solution]

Like this:

count({<Status*={'AAAAAA','BBBBBB','CCCCCC'}>} Id)

The *= is what's doing the work.  When you just use =, you're saying "exactly these values, no matter what I select".  When you use *=, you're saying "the intersection of what I've selected in Status and these values".  I probably use *= more often than = because I'm trying to limit the selections, not override the selections.

[#3]

Perfect!!

Thank you!!!

Regards,

Rodrigo.