Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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
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