Sum of table row depending on another row

Queries and Resources
1

Hi, I have the following table:

ID   PRICE   PROPERTY
0    50      1
1    81      2
2    69      1
3    125     2
4    108     1

I want to get the sum of all rows with a property value of 2. I know I can get the price sum of all rows with:

{{ _.sum(table1.data['PRICE']) }}

But how can I include the condition of the property value?

2

There may be a simpler way I'm unaware of, but you could use a transformer to do this:

image
image1676×812 102 KB