Is there a way to combine this so that the team shows on one row?

Summary: Is there a way to pull the team on one row instead of duplicating per territory role?

Content (required): I am trying to create an analysis for sales. The territory name could be multiple. Therefore it causes the rows to duplicate. We can get this to work with a pivot table when we pull for a specific account name.

But we need it to work base on industry. Does not work

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

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