Duplicate rows only

Hello.
I want to make a list in a PDF where only the rows that are duplicates of the [AMOUNT] column appear.
That is, the rows with duplicate [AMOUNT].

The structure of the table is:
[IDFRA]
[CONCEPT]
[AMOUNT]

Can you help me?
Thank you!!!

Solved Solved
0 4 128
1 ACCEPTED SOLUTION

Use a START expression with a formula such as:

FILTER( table , 
  ISNOTBLANK( FILTER( table ,
    AND( [amount] = [_THISROW-1].[amount] , [id]<>[_THISROW-1] ) 
  ) )
)

 

View solution in original post

4 REPLIES 4

Use a START expression with a formula such as:

FILTER( table , 
  ISNOTBLANK( FILTER( table ,
    AND( [amount] = [_THISROW-1].[amount] , [id]<>[_THISROW-1] ) 
  ) )
)

 

Thank you.
I have tried and the list appears blank.
It does not return any records.

Oops, I must have had a brain fart while writing the formula I was thinking of. Just updated it in my first comment.

AWESOME !!!
Thanks a lot!!!
Works!!!!!!!!

Top Labels in this Space