Skip to Content
0

Webi Report: Remove Duplicate Values

Sep 18, 2017 at 01:26 PM

35

avatar image
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Sep 18, 2017 at 01:34 PM
0

can you share sample data.

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

Apply filter on var where equal to 1

Share
10 |10000 characters needed characters left characters exceeded