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-projectSilver 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- Matef89Copper Contributoris there an easier way ?
- John-projectSilver 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