Help me to have this report...

[#1]

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

Sample Output:

Territory	Brand	Sales	Target
A	Brand A	13,000	16,000
	Brand B	6,000	5,000
B	Brand A	14, 000	10, 000
	Brand B	50, 000	55, 000
C	Brand A	10, 000	15,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

[phaneendra_kunc]

Are you doing a left join with Targets table?

Do the concatenation and ignore the fileds that doesnt need in set analysis...

Post a sample..if possible...

Regards,

phani

[Anonymous]

Hi Bill,

Given the nature of the data (no Territory in Transactions table) you cannot tell anything about the Product Sales by Territory.  If you had it, the right thing to do would be concatenation of both tables, as Phani said.

Regards,
Michael

[#4]

Hi Guys,

That's what Im thinking, there is no territory in transaction table so there's no chance of getting sales per territory.

Thanks for the reply.