3 Replies Latest reply: Mar 4, 2012 8:54 PM by Bill Ringer Salalima RSS

    Help me to have this report...

      I got problem in architecture, it has the same amount in each territory.

       

      Sample Output:

       

      TerritoryBrandSales
      Target
      ABrand A13,00016,000

      Brand B6,0005,000
      BBrand A14, 00010, 000

      Brand B50, 00055, 000
      CBrand A10, 00015,000

       

      I got a problem, in each brand of each territory outputs the same sales. Below is the sample table fields.

       

      Transactions:                    Targets:

           Product Code                    Territory

           Sales                                Product Code

                                                   Target Amount

       

      As you can see in the fields, it doesnt have "territory" field in the Transactions table, that is why it outputs the same sales in each territory. What should I do? Help me please, need it urgent! Thanks.

       

      Best Regards,

       

      Bill