All,
I decided it's about time I looked at using these PivotTable thingies.
I've ran into problem already.
I have an ammount of data that is brought into a workbook using MSQuery from an Access Database.
The Fields/Headings I'm importing are:
{"calldate","cbdate","leadcode","outcome","operator","link_id","Type","DMCYN","NoInterest"}
An explaination of the fields I need to look at currently are:
calldate: is the Date AND Time stamp, combined, of the record
operator: User NT login
DMCYN: Always Y or N
I've been through the PivotTable wizard.
I selected the range tblCallLog, which is a Dynamic Named Range.
I placed:
calldate in Row
operator in Column
and Count of DMCYN
Finish.
Now for my question.
the calldate is in the following format
24/04/2002 18:17:02
therefore every seccond in accounted for.
how do I Group them so the Row part reads
12:00
13:00
14:00
and has the count of TIME>=12:00 and <13:00
Another problem is that I'd like to select the date but can't uae the calldate in both Page and Row
this is not very well explained but I can answer any questions as required.
All your help will be greatly received.
Many thanks
I decided it's about time I looked at using these PivotTable thingies.
I've ran into problem already.
I have an ammount of data that is brought into a workbook using MSQuery from an Access Database.
The Fields/Headings I'm importing are:
{"calldate","cbdate","leadcode","outcome","operator","link_id","Type","DMCYN","NoInterest"}
An explaination of the fields I need to look at currently are:
calldate: is the Date AND Time stamp, combined, of the record
operator: User NT login
DMCYN: Always Y or N
I've been through the PivotTable wizard.
I selected the range tblCallLog, which is a Dynamic Named Range.
I placed:
calldate in Row
operator in Column
and Count of DMCYN
Finish.
Now for my question.
the calldate is in the following format
24/04/2002 18:17:02
therefore every seccond in accounted for.
how do I Group them so the Row part reads
12:00
13:00
14:00
and has the count of TIME>=12:00 and <13:00
Another problem is that I'd like to select the date but can't uae the calldate in both Page and Row
this is not very well explained but I can answer any questions as required.
All your help will be greatly received.
Many thanks