Show only 1 Labor value per project.

satishkurra Registered Posts: 8

Hi Team

Trying to achieve the result by joining and then applying the window function to get Labor only in 1 record for project instead of all records.

Attached is the data and the current o/p vs desired output

Please help me in getting this answered to derive the solution

Operating system used: Browser

Best Answer

  • satishkurra
    satishkurra Registered Posts: 8
    Answer ✓

    Hi All

    Able to achieve this using window function by selecting row number and once done, applied formula to get the data to show only 1 time for project as below


    It worked. Thanks

Setup Info
      Help me…