Skip to Content
0

Hide double row in a table

Apr 10, 2017 at 04:10 PM

56

avatar image

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?

10 |10000 characters needed characters left characters exceeded

Hi,

Right click on the table>> properties and check "Avoid Duplicate Row Aggregation".

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Apr 10, 2017 at 04:34 PM
0

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

Apply filter on show/hide variable where equal to1

Share
10 |10000 characters needed characters left characters exceeded
Pavel Prokoshev Apr 11, 2017 at 08:59 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

apply the nofilter() on Count_Doubles column.

=nofilter([Count_Doubles])

0
Pavel Prokoshev Apr 11, 2017 at 10:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded