Summarising info from a table with 2 variables
 

Hello,

I'm trying to find a way of automatically interrogating info from a table
with a series of data in columns, including MONTH and TEAM. The table
records site visits, with each line recording a separate visit.

In particular, I want to be able to automatically calculate the number of
visits achieved by each team per month. At the moment, I can't figure out
how to get it to look at all the variables. A colleague suggested a pivot
table, but I can't make that work either. Please help!

Many thanks.

Summarising info from a table with 2 variables
 

Post a small sample of your data, together with details of the columns
you use, so that we can visualise what you have.

Pete

On Dec 14, 5:06*pm, Ned Harrison
wrote:
Hello,

I'm trying to find a way of automatically interrogating info from a table
with a series of data in columns, including MONTH and TEAM. *The table
records site visits, with each line recording a separate visit.

In particular, I want to be able to automatically calculate the number of
visits achieved by each team per month. *At the moment, I can't figure out
how to get it to look at all the variables. *A colleague suggested a pivot
table, but I can't make that work either. *Please help!

Many thanks.

Summarising info from a table with 2 variables
 

Name Adress Team Month
1 A Jan
2 B jan
3 A Mar

OK, so I have something like the above, recording details from visits made,
including Team and Month.

I'm trying to sort the info by month (and quarter) & team, so that I can see
that (for example) A made 1 visit in Jan and 1 in Feb (and 2 in Quarter 1)
while B made 1 in Jan (and 1 in quarter 1).
Does that make sense?
Thanks

"Pete_UK" wrote:

Post a small sample of your data, together with details of the columns
you use, so that we can visualise what you have.

Pete

On Dec 14, 5:06 pm, Ned Harrison
wrote:
Hello,

I'm trying to find a way of automatically interrogating info from a table
with a series of data in columns, including MONTH and TEAM. The table
records site visits, with each line recording a separate visit.

In particular, I want to be able to automatically calculate the number of
visits achieved by each team per month. At the moment, I can't figure out
how to get it to look at all the variables. A colleague suggested a pivot
table, but I can't make that work either. Please help!

Many thanks.

.