Last year sales by salesman

[#1]

Hi,

I need to design the current year and last year comparison report by salesman.

For ex, consider the following table, the salesmans are changed for the customers over year, i want to show how the salesmans performed over the customers. that means, how much we sold to the same customers last year.

For SM1, current year(2013) sales amt is 22000(Cust C1 + C5),

for 2012 last year sales amt for SM1 should be 6000(Cust C1 + C5) based on the current year customer irrespective of the last year salesman.

similarly for SM2,

for Current year (2013), 4800 (for Cust C2+C3+C4),

for las year (2012),  5700 (for Cust C2+C3+C4)

Salesman	Customer	Date	Sales Amount
SM1	C1	2012	1000
SM1	C2	2012	200
SM1	C3	2012	3000
SM2	C4	2012	2500
SM2	C5	2012	5000
SM1	C1	2013	20000
SM1	C5	2013	2000
SM2	C2	2013	1000
SM2	C3	2013	2300
SM2	C4	2013	500

Could anyone help me to resolve this issue.

thanks in advance,

[techvarun]

Dude

    Your questing isnt clear. please provide me any excel document

[Gysbert_Wassenaar]

See attached qvw.

[#4]

Hi,

thanks for your reply,

your application working only i have customer data yealy,

If i have the data daily then hot change the script to make it work.

could you please help me.