You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Accepted answer

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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!