2 Replies Latest reply on Aug 23, 2012 11:03 AM by Tracy Rodgers

    Data Blending - Issues Combining Datasets

    Christopher Henderson

      Hi All

       

      I have two data sources, one Access Table the other an excel spreadsheet. Both of these sources have the field product number which is what I am using to link the data sources. The link works fine however I only wish to show a summary of the linked data. If I use the linking field in the view I either get very large table or overlapping text. Here is an example of what I mean.

       

      Data Set 1 - Fruit Sales

       

      Fruit ID

      Fruit Group

      Fruit Sales

      Fruit Quantity

       

      Data Set 2 - Fruit Cost

       

      Fruit ID

      Fruit Cost

       

      Required Output

       

      Summary of Fruit Sales and Cost by Fruit Group.

       

      As soon as I only look at the data by Fruit Group I loose the linking field and therefore the numbers, as before when I do add it to the details shelf I get the overlapping text.

       

      Is there any way around this?

       

      Cheers

       

      Chris