Sum Column Based on Distinct values in another column
I need to sum the quantity in one column based off the unique values of another column. I cannot remove the duplicates within the ETL because there are other columns with greater detail that would be lost if done. So i need a beast mode that would give me a result of 50 for the sample data below. Any help is appreciated.