4 Replies Latest reply on Jun 24, 2018 9:54 PM by Deepak Rai

    Select single row value in each partition and sum

    Courtney Poles



      Right now when I use window_sum() Time Team Worked = 7, I want it to equal 3. I want window_sum to sum using  just one of the Count Day User values Per User1. How can I select a single row value from each partition and then sum?

      Workbook attached.