Skip to Content

Hide double rows in a table with condition

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 30, 2017 at 10:25 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2017 at 10:58 AM

    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"

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2017 at 11:11 AM

    Thanks, Amit!

    This is what I need. Your trick approach!

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2017 at 10:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded