Skip to Content

Hiding records in table

I'm try to hide some rows in my table but unfortunantely. The hide by fomula function is not hide it.

Here is example of my tables:

Number Comment Date Comment2

1 asdrt 03/06/2017 test1

2 tgdrt 03/06/2017 test2

3 fgdfgdf 05/06/2017 test3

4 gfdgdfg 05/06/2017 test4

5 gdfgdfg 09/07/2016 test5

I need to get in my table records 1,2,3,4! Records 5 need to be hide!

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

4 Answers

  • Best Answer
    Mar 20, 2017 at 02:17 PM

    create Var=Count([ID];All) In ([ID])

    Add filter on Var variable where greater then to 1.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 17, 2017 at 03:55 PM

    create variable Show/Hide=RunningCount([Number])

    Apply filter on Show/Hide variable where not equal to 5.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 12:31 PM

    Thanks for your reply,

    Unfortunantely the defenitions of hiding string need to be like:

    If row has a more than one copy so its not to be hide else hide.

    Example:

    ID Text Date Commnet

    1101 Test01 11/11/2000 testcomm

    1101 Test02 11/12/2000 testcomm2

    1101 Test03 12/12/2011 terseres34

    1109 Test04 12/12/2012 rterterer

    1109 Test05 12/12/2010 ggdfkjgkdf

    1108 Text02 10/10/20111 test

    1107 Text05 12/12/2000 testtext

    1106 Test09 12/12/2000 gfdgdfj

    So here by example above I need correct formula or filter to hide rows which is not doubles by IDs

    Filter need to hide rows and return here below:

    ID Text Date Commnet

    1101 Test01 11/11/2000 testcomm

    1101 Test02 11/12/2000 testcomm2

    1101 Test03 12/12/2011 terseres34

    1109 Test04 12/12/2012 rterterer

    1109 Test05 12/12/2010 ggdfkjgkdf

    As you can see last three rows don't have double rows and thus they hide.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 03:29 PM

    Thanks Amit it Works!

    Well done!

    Add comment
    10|10000 characters needed characters exceeded