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.
You need to find another and additional evaluation like AND([ColumnA]=TRUE,[ColumnB]=โSomethingโ)
Tqvm, will try
Have tried this but the result still the same: AND([VisitedSUM]=TRUE,[Visited Places]=โYesโ)
Looks like VisitedSUM is Yes/No datatype. If Visited Places is also Yes/No datatype, then you just need: AND([VisitedSUM],[Visited Places])
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.
Thanks. Will try out this one.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |