Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Consolidating lines in a union report table — Cloud Customer Connect
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

Consolidating lines in a union report table

Question
40
Views
0
Comments
edited Jul 14, 2017 7:47PM in Reporting and Analytics Taleo Enterprise

Content

I have a union report below, in one of the unions I have req data and the last column is SUM(0)

In the other union I have all columns with the statement of '' except for the ID column, which reports the same value that I have in the first union, the last column reports prospects, which works good. 

If I only show the number of prospects the ID will consolidate and sum to 2 - works good. 

I need to be able to add in the other variables so the lines will collapse and show me the correct count of prospects for each ID.  I know the '' is throwing off the line but I don't know what to do to get it to consolidate with the first union.   Thoughts?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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