Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Combining 2 columns in SharePoint List

Posted on 2011-09-22
7
Medium Priority
?
286 Views
Last Modified: 2012-05-12
I have the following Sharepoint list,  It needs to be grouped by month, then I need to total the duration for each month. Duration is a calculated column of (End Time - Start Time).

Can someone help me how can I get the Total after each month.
                                                                  
                                                Start Time                End Time                             Duration

   Month   : August ¿(1)                                                      
 XXX      Sys Admins 8/17/2011 12:00 AM      8/18/2011 12:00 AM      1,440                         
   Month   : October ¿(1)
                                          
 XXX      Sys Admins 10/6/2011 12:00 AM      10/7/2011 12:00 AM      1,440                        
   Month  : September ¿(1)

XXX      Sys Admins 9/15/2011 12:00 AM      9/15/2011 3:00 AM      180
0
Comment
Question by:nsdlsandy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Assisted Solution

by:George K.
George K. earned 400 total points
ID: 36586230
First you change your view and add grouping by the month field.
Then you choose the column for which you need to sum.
0
 
LVL 13

Expert Comment

by:George K.
ID: 36586238
Have you reied the above?
0
 
LVL 14

Expert Comment

by:abhitrig
ID: 36587261
Do you already have the Month field? If not create a calc column called month and set the formula to =TEXT([Start Time],"mmmm"). Then create a view and set group by to this calc month filed.
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:nsdlsandy
ID: 36597014
So the list above is already grouped by month, I do have month view too..duration above is calculated column of end time - start time and they can be numerous within a month, and I don't get the option to do total on a calculated column.

My question is how to get the total of various durations within a month.
If I am missing something than can you please show mw in this or any other example.

Thanks,
SM
0
 
LVL 14

Accepted Solution

by:
abhitrig earned 1600 total points
ID: 36599212
If i understand you correctly, you are looking for the sum of all duration for sysAdmin in  a month.

So ideally you need a group by month, then dept(sysAdmin) and then duration.
http://techtrainingnotes.blogspot.com/2008/11/sharepoint-group-by-on-more-than-2.html

Or you can play around with xslt to display the totals...
http://geekswithblogs.net/SoYouKnow/archive/2010/03/30/sharepoint---summing-calculated-columns-by-groups-dvwp.aspx
0
 
LVL 1

Author Comment

by:nsdlsandy
ID: 36710223
Thanks I had looked at the techtrainingnotes link earlier and was not getting the right result but the second link has helped me a little with that. Thanks for those. Do you anything which can help me conditional formatting the cells?
Thanks,
SM
0
 
LVL 14

Assisted Solution

by:abhitrig
abhitrig earned 1600 total points
ID: 36711918
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question