Forum Discussion

Matef89's avatar
Matef89
Copper Contributor
Dec 25, 2022

Summary tasks calculate total of filtered items only

how to make project calculate the cost for only filtered items ?

  • John-project's avatar
    John-project
    Silver 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

      • John-project's avatar
        John-project
        Silver 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

Resources