Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dinesh,
You need one row with primary key 566565 in the table? you don't need any other Primary keys?
Yes I need all Primary Keys with more than one Con Numbers
Thanks In Advance
Dinesh,
Like this? but this what you had originally rt?
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...
Can you upload your file? then I can see what the issue is.
Sorry It's A confidential File
Thanks
Ok..can you upload dummy data which resembles your original data file. It will help...
Thanks
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