1 Reply Latest reply on Sep 6, 2012 3:22 PM by Tracy Rodgers

    How to aggregate results when you have duplicate data entries?

    Amer Ghanem

      I have some data about customer transactions. Transactions have types so I would like to aggregate on the types of transactions I have. The issue I have is in the Fact table, a customer might belong to multiple regions. so when I have the region in the data, one transaction for a customer, who is in two regions, will appear twice. I need the region so I can use that as a filter. For example, I have the following data:

      TransactionIDRegionIDCustomerIDTransactionTypeTransactionAmmountProduct1PercentageProduct2Percentage
      111w1005050
      121w1005050
      212w507525
      232w507525
      323s706040
      414s2008020
      521s301090

       

      I want my result to show something like

      TransactionTypeTransactionAmmount
      w150
      s300

       

      but I am getting

       

      TransactionTypeTransactionAmmount
      w300
      s300

      because transactions 1,2 are being added twice.

       

      Attacked is a workbook with the result. Any help would be greatly appreciated..

       

      Thanks.