Hello,
I know this question has been asked several times, but I was unable to find the answer. I am on Reportsmith, Oracle. I have a report that has several different earnings codes; therefore pulling multiple rows per employee. I have created separate derived fields for each earning code, so that now I have separate columns for each, but there are still multiple rows per employee. What is the derived field to combine into one row? (see below) thanks!!
code1 code 2 code 3
ee1 500
ee1 250
ee1 250
I know this question has been asked several times, but I was unable to find the answer. I am on Reportsmith, Oracle. I have a report that has several different earnings codes; therefore pulling multiple rows per employee. I have created separate derived fields for each earning code, so that now I have separate columns for each, but there are still multiple rows per employee. What is the derived field to combine into one row? (see below) thanks!!
code1 code 2 code 3
ee1 500
ee1 250
ee1 250