5 Replies Latest reply on Jun 7, 2017 11:40 PM by Helena March

    Remove SOME duplicate rows

    Helena March

      Hi everybody, I encountered this problem and can't figure out how to solve it.

       

      We have a report that states the status of invoices (1,2,3,etc). When the status changes, a new line appears with the new status, so there can be multiple lines for the same invoice.

      I want that when the status is "PAID", all the lines for that invoice to be filtered OUT.

       

      Current report:

      current.jpg

       

      How I need the Final report:

      final.jpg

       

      Appreciate your help/ideas so much!!