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):