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

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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