Skip to Content
0

Hide double rows in a table with condition

May 30, 2017 at 09:16 AM

45

avatar image

Hi community,

Need your help to hide some rows in my table with formula or filter.

Here below my example:

ID Date Description Status Sum

SD06879 03/12/2012 Test1 Reject 3

SD06879 06 /10/2012 Test1 Reject 3

SD06879 09/10/2012 Test1 Enable 3

SD05777 11/10/2012 Test2 Reject 2

SD05777 11/10/2012 Test2 Enable 2

SD06371 11/10/2012 Test3 Reject 2

SD06371 11/10/2012 Test3 Enable 2

I would like to hide double rows but with workable condition in Sum column.

Because Sum Column based by calculation double rows with NoFilter(Count([ID])

So just after the filter my table need to be here:

ID Date Description Status Sum

SD06879 09/10/2012 Test1 Enable 3

SD05777 11/10/2012 Test2 Enable 2

SD06371 11/10/2012 Test3 Enable 2

Is it possible also to add the condition for example to filter double rows by values of Status column?

sp6
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

AMIT KUMAR
May 30, 2017 at 10:25 AM
1

are you want to display only rows with Enable status and count all ID's?

If yes then filter on Status and select value Enable.in the count id's column paste below formula.

=NoFilter(Sum(Count([ID];All) In ([ID])))

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
May 30, 2017 at 10:58 AM
1

use this.Apply filter on V Show/Hide variable and select where equal to Show

V Show/Hide=If(RunningCount([ID];([ID]))=NoFilter(Sum(Count([ID];All) In ([ID])))) Then "Show" Else "Hide"

Share
10 |10000 characters needed characters left characters exceeded
Pavel Prokoshev May 30, 2017 at 11:11 AM
1

Thanks, Amit!

This is what I need. Your trick approach!

Share
10 |10000 characters needed characters left characters exceeded
Pavel Prokoshev May 30, 2017 at 10:44 AM
0

Thanks, Amit!

Not certainly, I need to get in my table only unique last rows. They have different satus, may be reject may be other one.

I've tried to use previous function like

=If ([ID])=previous([ID]) then "Y" else "N" but it's set for each dublicate row "N" and for the first "Y", But I need opposite "N" for eache dublicate and "Y" for the last row and no matter which status is.

Share
10 |10000 characters needed characters left characters exceeded