3 Replies Latest reply on Jul 26, 2016 6:55 AM by Keith Goodwin

    Grouping Rows With Blended Data Sources Duplicates Data

    Keith Goodwin

      Hello.  I'd like to figure out a way around this situation.

       

      I have a list of sales people, and would like to compare their sales from one data source, to their quota in another data source.

       

      The end result should look something like this:

       

      When I attempt to group common Cst Acct Manager ID's together,duplicate data appears in the sales column.

      Here is the relationships page

       

       

      What can I do to fix the value in the Sales column?

       

      Note:  There are obviously some issues with the Cst Acct Manager ID as a primary key.  I still didn't expect this outcome though, and I'm wondering how to work around this faulty ID system.