Skip to Content
avatar image
Former Member

Webi Report: Remove Duplicate Values

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 18, 2017 at 01:34 PM

    can you share sample data.

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

    Apply filter on var where equal to 1

    Add comment
    10|10000 characters needed characters exceeded