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:



      How I need the Final report:



      Appreciate your help/ideas so much!!