How to Remove Duplicate Rows from Pivot table in OTBI

Summary:

In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):