Make Alteryx seek a specific average

[RasmusTS]

Hi everyone 

I'm currently making a workflow, where based on a sample, the workflow should seek to remove rows so that the average will become XX.

To clarify, I have a large dataset and I only want to keep rows so that the total average is equal to, fx 150. 

Meaning that every row which does not conform with this, should be removed, ie: if I have 4 rows: 

250

200

150

100

I would want the workflow to filter out the row with 250.

Does anybody have any experience in this regard?

Thank you in advance!

[BRRLL99]

Please let if this is your output

I have taken avg from 4 rows and matched it with each row and then filtered only greater than rows

[hlee36]

I'm confused. 

If you have rows of 250, 200, 150 and 100 and filter out 200, you will have the average of 166.67 ((250+150+100)/3). But, you said the average should be 150.

Shouldn't you filter out 250 so that the average will be 150 ((200+150+100)/3)? 

Correct me if I'm wrong. Please clarify so I can attempt to solve this.

[RasmusTS]

That is what I meant. I'm sorry for the confusion/error.