#1
|
|||
|
|||
Sum the (filtered) remaining work column
I use a separate text column to indicate tasks assigned to various project managers. There are multiple sub-projects within the project. I've created a filter that shows tasks assigned per that column which then allows me to see remaining work, but I cannot find an easy way to sum the remaining work column. I currently copy and paste it into excel, but I'd like to do it all within MSP. Does anyone have a method for this? |
#2
|
|||
|
|||
Hi Brent,
Filtering does not change the summary values Consider grouping by the project manager assigned. The remaining work should be summarized by group. |
#3
|
|||
|
|||
Excellent suggestion. I have not used grouping to any great extent. This is a great quick solution. Thank you.
|
#4
|
|||
|
|||
You're welcome and thanks for the feedback.
|
Tags |
sum |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula to work from data column | masterdineen | Excel | 16 | 08-09-2012 07:52 AM |
Change Resource Time vs. Duration when Updating Work column | lylel | Project | 3 | 07-23-2012 06:09 PM |
Displaying Work Week instead of date in a column. | whitney07 | Project | 1 | 07-05-2012 02:27 PM |
definition of work column | ketanco | Project | 9 | 05-31-2012 05:15 PM |
adjusting remaining work per status date | ketanco | Project | 1 | 03-16-2012 06:02 AM |