If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with pivot table
I want to know how many employees I have working in a given half hour
with the state licensure they have. I have a table that has my employees, state licensure and each individual half hour segement they are working. When I view as a pivot table, the results are giving me all that have that specific state licensure. Example: @ 6am, I have one person with Alaska licensure, but the pivot table say 11 (that is my total staff with Alaska) How do I make this happen? Thanks in advance. |
#2
|
|||
|
|||
Help with pivot table
On Wed, 11 Nov 2009 16:51:41 +0000, Pecoflyer
wrote: HOW TO GET FURTHER HELP WITH A WORKBOOK For further help with it why not join our forums (shown in the link below) it's completely free, if you do join* you will have the opportunity to add attachments to your posts so you can add workbooks to better illustrate your problems and get help directly with them*. Also if you do join please post in this thread (link found below) so that people who have been following or helping with this query can continue to do so. Or you can use any newsreader (Outlook Express, Windows Mail, Agent, or any of hundreds of other free or fee programs) and connect to msnews.microsoft.com to get the help of hundreds of volunteers, and avoid the limitations of a forum which nags you to pay for a VIP membership, loads slowly, limits the number of responders, and just slurps posts posted on the FREE, OPEN newsgroups and claims credit for them. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Help with pivot table
Jimbo -
If this is Excel, please use the Excel forum. If this is a crosstab query (which is similar to a pivot) in Access, then just make sure your criteria includes the holf-hour segment you are interested in, or use that as your column headers. If this doesn't work, you will need to give us more information on your data structure so we can help you more. -- Daryl S "Jimbo" wrote: I want to know how many employees I have working in a given half hour with the state licensure they have. I have a table that has my employees, state licensure and each individual half hour segement they are working. When I view as a pivot table, the results are giving me all that have that specific state licensure. Example: @ 6am, I have one person with Alaska licensure, but the pivot table say 11 (that is my total staff with Alaska) How do I make this happen? Thanks in advance. . |
Thread Tools | |
Display Modes | |
|
|