Skip to Content

Hide double row in a table

Hi community!

I'm try to hide double rows in my table but unfortunantely. The rows also calculated by number of doubles.

Here is example for rows in my table:

NumberID Comment Date Comment2 Count_Doubles

1001 asdrt 03/06/2017 test1 2

1001 tgdrt 03/06/2017 test2 2

1003 fgdfgdf 05/06/2017 test3 2

1003 gfdgdfg 05/06/2017 test4 2

1005 gdfgdfg 09/07/2016 test5 1

I need to get in my table after filter or hide formula something like this:

1001 asdrt 03/06/2017 test1 2

1003 gfdgdfg 05/06/2017 test4 2

1005 gdfgdfg 09/07/2016 test5 1

Please explain how it could be achieve correctly through formula ? Or just hide formula for table?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 10, 2017 at 04:34 PM

    create variable show/hide=RunningCount([NumberID];([NumberID]))

    Apply filter on show/hide variable where equal to1

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 08:59 AM

    Thanks Amit, but this is not actually work correctly.

    I've set your filter in my table and some double string hide, but the Count_Doubles column also changed and set count to 1

    So here below I've now the next rows:

    1001 asdrt 03/06/2017 test1 "1"

    1003 gfdgdfg 05/06/2017 test4 "1"

    1005 gdfgdfg 09/07/2016 test5 "1"

    But I need the nextone:

    1001 asdrt 03/06/2017 test1 "2"

    1003 gfdgdfg 05/06/2017 test4 "2"

    1005 gdfgdfg 09/07/2016 test5 "1"

    Beware the count for each rows need to be more than 1

    So I think that could be some trick to just hide one of double row in a table, but I dont know what is actually to be.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 10:53 AM

    Many thanks Amit, your trick with nofilter is a best idea.

    Add comment
    10|10000 characters needed characters exceeded