As below image, I would like to remove duplicate doctotal amount and remain one line only per docno.
I could achieve by using for each row and delete duplicate lines. But for data row more than a million records, it is taking time and indexing problem might occur. So is there any other background coding to achieve this with faster without using for each row activity. Thanks.