Calculate value using values from different rows

am50

Hi,

I am trying to achieve below, not sure how to do this in Alteryx.

field1, field2, field3,value

a,b,c,10

x,h,z,50

d,e,f,40

g,h,z,100

j,k,l,150

The value field for the last row should be the sum of values coming from rows with specific filter something like sum of values where field1=x or g and field 2=h and field3=z 

patrick_mcauliffe

I'd agree with @BenMoss here; this is a little too vague of a question.  If you can post more about the actual use case it would be helpful.

That being said, I still decided to take a wild guess at this.

See the attached workflow.

CalculateValueUsingValues_AM50.yxmd