Average for multiple conditions

[Dennis229]

Hey there. I am trying to find the average for a column based on two conditions, but want the work flow to be dynamic if multiple conditions were added in the future. 

I basically want to replace the 2 summarize with a single tool but not sure what to use. 

[Felipe_Ribeir0]

Hi @Dennis229 

Please attach the input file

[Dennis229]

here

[Felipe_Ribeir0]

Hi @Dennis229 

One way of doing this is by using a batch macro

[binuacs]

@Dennis229 one way of doing this with the analytic app