Sum One Dimenstion based on DISTINCT other dimension
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