Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just use Sum(DISTINCT Deal$)