Conditional Running Sum possible?

[urbanmojo]

For example, saying i have a report grouped by Furniture Type, and model types in the details, with price.
Type Model Price
Chair Total Office Chairs: 40
Office X2 30
Home Y3 20
Office Y5 10

Table


I want to sum the price of all the "office" chairs (i.e. 40), and I want that to show in the group header. How can I accomplish this?

Thanks!

[Taqua]

Filter your data by creating a formula expression:

=IF([Type] == "Office"; [Price]; 0)

and then sum up that formula instead of the original price column.