How to remove duplicate rows in OBIEE analysis


    I have an analysis that is producing multiple rows as shown on the attached screenshot and I wanted to know if there is a way to eliminate the  duplicate rows. In this example the expected results is one row per job name per date.