Remove duplicate values in OBIEE
Is it possible to remove duplicate values in OBIEE?
In my report, columns A and B have unique values per line for an employee, however, column G is all the same value and it repeats itself to match the same number of lines of column A & B. The screenshot can probably demonstrate this a lot clearer than I'm describing it .
Is it possible to remove all but the bottom value in column G?
Thank you in advance for your help!