Hi, I need some help with a pivot table.
I have a dataset with four columns: Date, TimeInterval, QueueName, count Each row is then the count of items for that date for an time interval per Queue. In this case, the time interval is every half hour. So the data is basically the number of items per half hour for the last year for each queue. When I do a pivot table with TimeInterval as row and average of count in data. I essentially get the average per que for each time interval. How do I get the average of the sum of all queues per time interval? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
