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 

[BenMoss]

Hi.

Can you pass some more realistic sample data from both the input side and what the desired output would look like.

I’m finding it difficult to understand the problem here.

Ben

[patrick_mcauliffe · Accepted solution]

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.

[am50]

Thanks for the update. Sorry for not providing clear input data. I was able to find the solution using multi-Row formula.

i think your solution is better as it will not assume the rows are not -x or +x number of rows of original record.