View Single Post
  #3  
Old June 25th 07, 09:14 PM posted to microsoft.public.outlook.calendaring
Jason R. Senior
external usenet poster
 
Posts: 1
Default How can I total on columns in a view?

Could I write a Macro within Outlook which at the click of the button could
generate a simple report for me?

"Sue Mosher [MVP-Outlook]" wrote:

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