How can i filter row that have the same content in a table?

[Alessio_Cassamagnaga]

Hello everyone, i would like to know if, with filter, is possibile to filter row that have the same content, so that appear only one row
For exemple in my table i would like that if the content in the column “Tipologia e Fase” is the same, appear only one row and not 2 row like in the photo

Thanks a lot for your response

[Piet_Strydom]

Hi Alessio,

Could you provide a copy of the document, and some more information?

Are you filtering on the “tipologia e fase” column? If so, which of the entries should be presented?

It could be as simple as adding .first() to a filter in Tipologia…

Regards
Piet

[Alessio_Cassamagnaga]

Thanks for the response

Here a copy of the document https://coda.io/d/Coda-community_ddaj2457igX/Coda-community_suJEY#_luCrS

I would like that in the column “Tipologia e Fase”, with a use of a filter in the table, don’t appear the duplicate value. So, for example, the “Definizione OKR nella fase di onboarding” appear one time and not 3.

I hope it’s clear and thanks for your response
I

[Math_24]

Good morning,

I have completed your doc. If I have understood correctly

[Alessio_Cassamagnaga]

Hi Math, thanks for your response.
I’m seeing but is not the same that i need.

What I mean if is possibile with filter, to hide duplicate values of the column “tipologia e fase”, so the final result (with the filter that we need to inser) will be this table https://coda.io/d/_ddaj2457igX/Coda-community_suJEY#_lu2OL

Thanks

[Math_24]

In the example I’ve set 2 to display.
But you can easily set just one in the filter.

Then why report and not the other 2?

If you absolutely want to report if More one item, you’ll have to use a different method/organization or add specific filter.

[Rickard_Abraham]

Try this filter formula

thisTable.Filter(thisRow.Tipologia e fase=CurrentValue.Tipologia e fase).First() = thisRow

Original

Filtered

[Alessio_Cassamagnaga]

Thank @Math_24 and @Rickard_Abraham for your help.

You tell me the solution and now it works

Thanks a lot and have a nice day!