cancel
Showing results for 
Search instead for 
Did you mean: 

Requirement for Joined Data Source

Former Member
0 Kudos


Hi,

   We have a requirement to generate the report between what was planned for an Employee and Account in Sales Planning vs the planned revenue split for each opportunity for the month on month values. Like for Example:

For Jan and feb,2015 we planned that Employee 1 will generate a reveune of 10000 each USD from Customer1.

And for Jan he created one opportunity of 3000 USD for the revenue split as Jan 1500 Feb 1500

Now the report should have the result as follows:

                                        Forecast Jan     Forecast Feb     Planned Jan     Planned Feb     

Customer1 Employee1       10000               10000                1500                    1500

This report is to check the performance of the sales employees. Can you kindly suggest what kind of join we can create to get this output.

Thanks and Regards,

Anupam

Accepted Solutions (1)

Accepted Solutions (1)

ankurgodre
Active Contributor
0 Kudos

Hello Anupam,

The joins works the same way as they usually work in other programming language, specifically the Inner & Left outer Joins. You need to first understand the concept of Joins as to how does each one work and then create them accordingly.

For example, if you want unique records corresponding to a key field which exists in two different places, then you should pick an Inner Join.

If you want all the Unique as well as Non-unique field values then a Combined data source should work.

BR

Ankur

Answers (0)