Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with Pivot Tables.
Hello,
I am trying to create a pivot table/Chart, but I am having some difficulties. I am gathering a list of users who are logged onto a system at the top of every hour (1:00, 2:00 etc). I now take this list at the end of each month and I now need to find the Max number of users for the hour, as well as find the Average number of users for the given hour. I am having some difficulties getting the Pivot table to show me the Max and the Ave information. Here is the list. Date,Time,User 10/05/2007,1:00,test1 10/05/2007,1:00,test2 10/05/2007,1:00,test3 10/05/2007,1:00,test4 10/05/2007,2:00,test1 10/05/2007,2:00,test2 10/05/2007,2:00,test4 Etc.. 10/06/2007,1:00,test2 10/06/2007,1:00,test3 10/06/2007,1:00,test4 10/06/2007,2:00,test1 10/06/2007,2:00,test2 10/06/2007,2:00,test4 10/06/2007,2:00,test5 Etc.. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with Pivot Tables.
On 8 Ott, 20:29, Nicholas wrote:
Hello, I am trying to create a pivot table/Chart, but I am having some difficulties. I am gathering a list of users who are logged onto a system at the top of every hour (1:00, 2:00 etc). I now take this list at the end of each month and I now need to find the Max number of users for the hour, as well as find the Average number of users for the given hour. I am having some difficulties getting the Pivot table to show me the Max and the Ave information. Here is the list. Date,Time,User 10/05/2007,1:00,test1 10/05/2007,1:00,test2 10/05/2007,1:00,test3 10/05/2007,1:00,test4 10/05/2007,2:00,test1 10/05/2007,2:00,test2 10/05/2007,2:00,test4 Etc.. 10/06/2007,1:00,test2 10/06/2007,1:00,test3 10/06/2007,1:00,test4 10/06/2007,2:00,test1 10/06/2007,2:00,test2 10/06/2007,2:00,test4 10/06/2007,2:00,test5 Etc.. Thanks in advance. For pivot, cross-tabs / charting from Excel, you can also, in case you have problems or limitations, use this free tool: http://www.datatime.eu/download.aspx It will also allow you to create all the aggregations or grid functions you need, allowing drill down and Roll up on any dimension. -P ---------------------------------------------------------------------------*------------------ Providing Excel Users with the world's best Reporting Solution |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |