Forum Discussion
Matef89
Dec 25, 2022Copper Contributor
Summary tasks calculate total of filtered items only
how to make project calculate the cost for only filtered items ?
John-project
Dec 25, 2022Silver Contributor
Mate89,
Apply the filter and then group the tasks using Project's Grouping feature.
For example, in the following simple plan the Flag1 field is the criteria for filtering.
Now the filter is applied and then grouped on the Flag1 field.
John
Matef89
Dec 27, 2022Copper Contributor
is there an easier way ?
- John-projectDec 27, 2022Silver Contributor
Matef89,
Short answer, no.
You could use a custom Cost field that is only populated for those tasks that are selected by the filter and then use the sum rollup for the summary task. Or, a simple macro could be used to sum up only the filtered tasks and write the cost into a separate Cost field.
John