Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping by 1+,2+,3+ etc

Status
Not open for further replies.

mbryantuk

Programmer
Aug 3, 2007
29
0
0
GB
Can think of how to do this

I need to count the number of times someone has acheived at least one contact for a dialler.

the output needs to have columns of 1+,2+,3+ and to be dynamic in a matrix

and rows of counts

the dataset has a timescalled column for each record so for the value for the column needs to count how many records have 1+ calls for the first group and 2+ for the next and so on.

e.g.

capture.png


sorry if this doesnt makes sense.

Matt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top