I have connected two tables “product code” column include repeated items “Prices” include prices of each item…
What i want to calculate is Sum of all “Prices” column for non repeated “product code” items
Example
Product Code Price
XX12012 12.00$
XX11414 24.00$
XX12332 15.00$
XX11414 24.00$
XX55001 37.00$
XX12012 12.00$
Calculated field SUM = 12.00+24.00+15.00+37.00 = 88.00