Hi All,
I am trying to develop a report in webi where i would like to see 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 !!!
I am trying to develop a report in webi where i would like to see 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 !!!