2 Replies Latest reply on May 15, 2013 6:09 AM by Martin O'Rourke

    View Data - multiple data sources?

    Martin O'Rourke

      Hi,

       

      I am attempting to create a waterfall report which pulls in Leads from one database table, and Opportunities from another (two data sources, joined at the Region level, for example). The intended output is as follows:

       

      RegionLeadsOpportunities
      APJ10010
      EMEA20020
      Latin America505
      North America30030

       

      I would like users to be able to right-click and View Data relevant to each column i.e. if you click on View Data when selecting the Leads column, you will see data from the Leads source, and Opportunity data if you click on View Data in the Opportunities column. My problem seems to be that I can only View Data from the primary source i.e. in the above, if the Leads data is my primary source, I cannot View Data from the Opportunities data source.

       

      Is there any way around this, or will I need separate tables?

       

      Thanks,

      Martin