Summarising info from a table with 2 variables

  • Thread starter Thread starter Ned Harrison
  • Start date Start date
N

Ned Harrison

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.
 
Post a small sample of your data, together with details of the columns
you use, so that we can visualise what you have.

Pete
 
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
 
Back
Top