Sunday Challenge: Dimension colour with 'floating' dimension

[adamdavi3s]

Hi All,

We're analyzing two sets of the same data using a floating dimension sort of thing (works really well for us).

This way we can select two sets of the 'same' dimension and perform a comparison. The detail of this isn't really in the attached document, but the relevant bits are.

However I would like to be able to colour the dimension backgrounds in the table to highlight which 'set' the dimension belongs to e.g.

trust A = green

trust B = red

anything else = yellow

Plus then the bubbles in the scatter chart to be the same

I've tried various formula to get it to work, obviously colouring for TrustA when there is just one selection is easy, but I can't wrap my head around what would work.

Note that our dimensions are not just as straight forward as a-f so hard-coding their values into a formula must be avoided if possible!!

[swuehl · Accepted solution]

Maybe like this?

[#3]

Here is one way...

[adamdavi3s]

Thank you both!!

I'm going with the match formula as that is the one I am used to, can't believe I didn't think of that!

Thank you once again