How to remove duplicate rows in OBI EE report ?

There are different ways to filter duplicate rows in OBI EE report.

Process 1:
My report contain a column, with duplicate data.

using DISTINCT function in column Edit formula we can filter the duplicate records.
DISTINCT("Share Measures"."Share of Region Dollars")

Process 2:

Rpd-->BMM--> Double click on Logical Source and check the "Select Distinct Values" Option for that table.