• Self Union Your data Twice
• Write a Calculation
• Exclude Null and here it is:

\

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to close Thread

Sorry..I am out of Ideas on this , but Have you tried the above and as You said your calculations went bad..I don't think so that happens.

Hi Rafael,

You could do this with sets, but you could only display one set at a time due to the conflicts (i.e. a person who is IN the 7-12 group is also IN the Youth group).

I'm still not 100% sure of your requirement though, wouldn't this be better arranged as a separate column in your data ?

HTH

Peter

With a parameter and a zinger of a calculated field

if [Parameter] = 1 then [Set 1]

if [Parameter] = 2 then [Set 2]

end

HTH

Peter