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

      Hi,

       

      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.

       

       

       

      Thanks!

       

      Courtney