Display Multiple values from Selected Field

[sivasai_k]

Hi Guys,

Thanks for your help In Advance...

I have data as follows.

Id,     Name,

1,     a,

1,     b,

2,     a,

2,     d,

2,     e,

3,     f,

4,     g...like wise.

I want to display values in a Table as follows.

If user selects Name='a' it should display following values in a "Table"

Name
a
b
d
e

If user selects Name='f' it should display following values in a "Table"

Name
f

Thanks.

[sunny_talwar · Accepted solution]

In your expression, try a set analysis like this

Sum({<Name, Id = p(Id)>} Measure)

[sivasai_k]

Thank you so much ... Sunny...

Its Working as i expected