Duplicates

[dseelam]

Hello,

I want to show 3 columns in a pivot table one with primary key, status and other with con numbers

I want to show only duplicate Primary keys with status=''Act" associated con numbers

Header 1	Header 2	Header 3
Primary key	status	Con Numbers
1	act	0
1	act	1
2	act	3
2	act	6

I don't want to show Primary key with out duplicates (which are normal)

Thanks In Advance

[#2]

Dinesh,

You need one row with primary key 566565 in the table? you don't need any other Primary keys?

[dseelam]

Yes I need all Primary Keys with more than one Con Numbers

Thanks In Advance

[#4]

Dinesh,

Like this? but this what you had originally rt?

[dseelam]

You are absolutely right but when I try the same in my Original QVW It Is Hiding The Active

AND it is showing other Status like ho, bill etc...

[#6]

Can you upload your file? then I can see what the issue is.

[dseelam]

Sorry It's A confidential File

Thanks

[#8]

Ok..can you upload dummy data which resembles your original data file. It will help...

Thanks

[dseelam]

Hello Padmaja,

You are absolutely right in case you using data source-excel sheets because I tested using dummy data in excel,

I think there is some thing wrong in my data using from DWarehouse.

One more concern is how can you represent the above aggr Fun in text object for count of primary keys with act status and having 2 con numbers ?

Thanks