Webi Report: Remove Duplicate Values

[Former Member]

I have a report with the following data:

Client Id

Date income added

Source of income

Monthly amount

Provider

I want to only display the rows where Date Income Added is unique. I want to see duplicate rows for Client ID, Source of Income, Monthly Amount, and Provider.

How do I go about accomplishing this?

[amitrathi239]

can you share sample data.

or try to add var=runningcount(Date income);(Date income))

Apply filter on var where equal to 1