Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community--I need some help!
I am trying to sum (Price) column, but only for unique Project ID#s in another column. Some Project IDs appear more than once, but I only want to sum them one time. I've tried aggr functions and some load DISTINCTs with no success.
I want to Sum dimention PRICE for distinct PROJECT ID#s
Thanks for taking time to help!
Can you upload some temp data so that we can see why load Distinct or aggr
is not working