2 Replies Latest reply: Jan 27, 2012 2:11 AM by susant Kumar swain RSS

    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

       

      Thanks for taking time to help!