Help with set analysis / comparative data / generating list of values

[adamdavi3s]

Hi All,

I am trying to create a specific piece of analysis within an existing dashboard but I am stuck at one bit.

The attached is obviously hugely simplified and the logic behind the two distinct selection boxes and data island for trust are set in stone.

Included in the data is an ID, then a READ ID which signifies a readmission in this case.

The READ ID is an existing ID, but I need to show against the original ID the count of READ ID.

This works great and I can count these fine.

What I then want to do, is create a list of the READ ID which I can then use in set analysis to produce a sum of the cost associated with READ ID when READ ID = ID

This works perfectly for my TRUST A selections, but I just can't get the set analysis right to generate the list for TRUST B. I am sure it is something really simple but I just can't sus it out!

Many thanks in advance for the help, hopefully the attached makes more sense.

[adamdavi3s]

Hi,

Not a problem in the slightest, I really appreciate the help thank you!

I had, but only in the full version which didn't work although it does work perfectly in the cut down version.

I think there must be something additional in the full version which is causing the issue so I will see if I can re-create the issue by building more into the cut down

Thank you for all the help so far! I only unmarked your answer as correct and changed it to helpful so it didn't show as answered, no offence was meant by doing that!