Show only Duplicate records in Webi Report

[kv444]

Hi All,

I am trying to develop a report in webi where i would like to show only duplicate records in the report and would like to drop the records that are unique from the report.

For Example i have a column in the report:

Item:
Laptop
Phone
Phone
Phone
watch
pen

Here i want to see the column with Item values that are only in "Phone" category and drop the laptop,watch and pen records from the report.


Could you please help me figure out how i can achieve this..


Thank you very much for your help in advance !!!

 

[PWD]

Hi, just revisited this. If you have a solution, I'd like to hear it. I think I'd try creating a variable that counted the items. If you put that in a crosstab and qualify that column where count<>1, that might work.

Many thanks,
D€$

 

[kray4660]

FYI: I was trying to something similar. Just show the top five results in a group. Never could get it to work properly.