Hide double rows in a table with condition

[Former Member]

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?

[Former Member]

Thanks, Amit!

This is what I need. Your trick approach!

[amitrathi239]

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"

[amitrathi239]

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])))

[Former Member]

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.