hi guys,

i hv following data,

i have the table value:

state AgentName Agenttype Timecreated amount

Kolkata 000123AA Distributor 2012-08-01 0.00

Kolkata 000123AA Distributor 2012-08-01 2.00

Kolkata 000555VB Distributor 2012-09-04 10.00

Kolkata 000555 VB Distributor 2012-09-05 10.00

mumbai 000567 AD Agent 2012-09-05 100.00

mumbai 000567 AD Agent 2012-09-05 200.00

i need o/p like ,

state AgentName Agenttype dailysum weeklysum monthlysum

Kolkata 000123AA Distributor 15 25 50

Kolkata 000555VB Distributor 45 110.00 500

mumbai 000567 AD Agent 67 810.00 1000

tnkx in regards

b raj