Show only 1 Labor value per project.

[satishkurra]

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

[satishkurra · Accepted solution]

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

if(rownumber==1,Labor,0)

It worked. Thanks