Set Analysis or Scripting?

[#1]

Hi All,

What approach is best for this problem?

I have a table

ID	ID2	Date
S-1	1	11/17/2012
S-2	1	12/12/2012
R-1	2	1/17/2012
R-1b	3	5/4/2012
R-1c	4	6/12/12

I need to get all the ID that have a count of 1 in ID2.

if(count(ID2)=1, ID)

So I need to get all the ID with only 1 count for ID2 and the specific date.

How can I achieve this?

Answer base on the table:

IDs..

R-1 - 1/17/2012

R-1b - 5/4/2012

R-1c - 6/12/12

I need to show this in Pivot Table.

Thanks,

Donna

[sujeetsingh]

Just go with set analysis

use calculated dimension...only({$<count(id2)=1>}ID)..

in expression just give ...Date

hope this help you..

[#3]

try with this expression :-

if(aggr(nodistinct count(ID2),ID2)=1,Date)

dimension :-

ID

[#4]

okay, i will try this one