View Single Post
  #2  
Old June 25th 07, 08:59 PM posted to microsoft.public.outlook.calendaring
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default How can I total on columns in a view?

The alternative is to export to Excel and run a pivot table. Outlook can't do math like that in views.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Jason R. Senior" Jason R. wrote in message ...
I have a simple view which has two columns. Subject and duration. I am
grouping on Subject. What I am trying to accomplish is this: I want total
hours worked on each Subject. My subjects are project numbers, such as
P-12345 and P-45678. I want the view to show P-12345 | 10 hours. Inside
that ten hours may be 5 different appointments, all with the Subject P-12345.
My view does properly group appointments by Subject, but surprisingly I see
no option in Outlook to total on a numeric field, such as duration. This
means I have to manually add up all the individual durations to get a total
duration.

Does anybody have any ideas short of exporting my calendar information into
Access?

Ads