Suppose my table lists some deals multiple times. In the example below Deal B is listed twice.
Deal ID
Deal $ Total
A
5000
B
7000
B
7000
C
2000
I want my pivot to sum only distinct deal IDs. In other words I want deal B to count only once so the total $ of all deals combined is 5k+7k+2k=14k vs. 21k. Is there an easy way to do this in a pivot? thank you.
