Dear All Experts ,
I have a report with duplicate data as below:
DocNo | JobCode | PartNo | Amount
----------------------------------------------------------------------------
0001 J01 P01 100
0001 J01 P01 100
0002 J02 P01 500
0002 J02 P02 700
I would like to have a sum which is only select for distinct of DocNo, JobCode, PartNo. The end resuld would be
DocNo | JobCode | PartNo | Sum
----------------------------------------------------------------------------
0001 J01 P01 100
0002 J02 P01 500
0002 J02 P02 700
Any idea how to do this? is it should insert running total and at evaluate filed, type some formula? Please advise.. thanks