Hi guys i have a big table and i want to get some data from it
table name productivity Content this columns
Date1,ACC_NO,Balance,Collector,Call_Visit,Trials,PTP_Type,PTP_Amount,Kept_Amount
How i want to get Acc_No , Total Balance, Count Collectors Without Repeat data,Call_Visit Without Repeat Data
count Trials without repeat data, Count PTP_Type without repeat data, Count PTP_Amount without repeat data, Count Kept_Amount Without repeat data
Sum total Kept_Amount With data that hide
that meaing i want to get sum some data that i want it to be repat
this a ex file in excel:
set date = 01/08/2013
i have 6 rows that have
3 [Collectors] => Count
6 [Acc_No] => Count
480104 Total [Balance] => SUM
2 [Call_Visit] => Count
6 [Trials] => Count
1 [PTP_Type] => Count
1 [PTP_Amount] => Count
9000 [PTP_Amount] => SUM
That result that i want
when [date] be 01/08/2013 and [Agency] = abo shady
This Excel Link:
ivity.xls">https://www.dropbox.com/s/dmfmz3eh9mfi54w/productivity.xls[
^]
I want this code so fast
Thanks Guys