This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Duplicate rows only

Posted on 02-02-2023 10:31 AM
Andres_Belmonte
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

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 172
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

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

Jump to Solution
4 REPLIES 4
Top Labels in this Space