Hi Guys
im in the process of creating a simple MI package for work that allows me to keep track of the departments performance on an individual level.
We have a simple submission form that send data to a "raw data" page containing the following details.
Business week - Todays Date - Agent name - sales - conversion
Ive then created a table with data validation list at the top that allows the manager to pick his name, "which populates all his team in the table below" then a date "to show that days performance" all populated from the raw data page..............my issue is.
How on earth can I ask the table to populate a sum total for the business week? as each manager submits data daily, each agent will have multiple entries for the same business week, at the moment i've been using "vlookup(data$data" which works fine but obviously wont for multiple entries.
Hope that makes sense? any ideas guys? Access is out of the question as the business doesnt use it.
cheers guys
Paul
im in the process of creating a simple MI package for work that allows me to keep track of the departments performance on an individual level.
We have a simple submission form that send data to a "raw data" page containing the following details.
Business week - Todays Date - Agent name - sales - conversion
Ive then created a table with data validation list at the top that allows the manager to pick his name, "which populates all his team in the table below" then a date "to show that days performance" all populated from the raw data page..............my issue is.
How on earth can I ask the table to populate a sum total for the business week? as each manager submits data daily, each agent will have multiple entries for the same business week, at the moment i've been using "vlookup(data$data" which works fine but obviously wont for multiple entries.
Hope that makes sense? any ideas guys? Access is out of the question as the business doesnt use it.
cheers guys
Paul