Hi all, i have a problem with hiding rows. I ...

[sumawa_quest]

Hi all, i have a problem with hiding rows. I have filtered data based on a condition and returned two result, i.e YES and NO. Both seen as the result and in many rows. My question:

How do I display only 1 row for the YES, instead of many YES rows ?

Tq.

[Aleksi_Alkio]

You need to find another and additional evaluation like AND([ColumnA]=TRUE,[ColumnB]=“Something”)

[sumawa_quest]

Tqvm, will try

[sumawa_quest]

Have tried this but the result still the same: AND([VisitedSUM]=TRUE,[Visited Places]=“Yes”)

[Bellave_Jayaram]

Looks like VisitedSUM is Yes/No datatype. If Visited Places is also Yes/No datatype, then you just need: AND([VisitedSUM],[Visited Places])

[Aleksi_Alkio]

If you see more records than just one, you have more records where the AND evaluation gives TRUE. So… the reason is not the format, it’s the structure or the data itself.

[sumawa_quest]

Thanks. Will try out this one.