Sum values of non-repeated items in other column

Q&A
,
1

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

2

If you are doing the joins at SQL level, you can add row_number() over product code and at quicksight level, do the sumif calculation based on row=1 then you will get the desired results.
I hope this helps.