Summing filtered rows in another databand?

[ericp]

Hello,

I was wondering if it's possible to do a SUM calculation if my if my master databand filters out rows (look at screenshot - I want to filter out the Total Prior + Total Future Costs row in my table, but still show their numbers at the bottom)

This is the formula I've been using {Sum(Projects_ProjectFunding.Prior)} and it works when the rows are visible, but the formula doesn't work once the filter is enabled the those 2 rows are hidden.

Please assist (:

[Lech Kulikowski]

Hello,

Please try to use the Totals.Sum() function:
{Totals.Sum(Projects_ProjectFunding, Projects_ProjectFunding.Prior)}

Thank you.