Filtering by multiple fields and conditions

[poisedon]

Hi all! 

I Loaded from 100+ xml files many fields and i have a table like this. Now in my Sheet I need to apply a filter for see all Company who have sum of "Value Mar" < Average Value (For example for A company sum of value mar is 38 and average value is (42+64 / 3) = 35 Any idea? Consider in my editor there is a cycle taking each xml file with those fields

[NhanNguyen · Accepted solution]

Let's try this: first, create a variable hold the avg value of 'Value Mar' and then calculate sum of value group by companies. After that, you could use:

- if function in the table to filter out companies that sum > avg

- or 'Where' clause in the script to exclude companies that sum  > avg