Multi field formula combination of row and column

[janani_venkat]

Hi,

I've transposed my data as per below to summarize the data. Once this is transposed, I'd like to filter data - if for each business line in any of the months the value is greater than 1000, then the "filter" column should say YES, else NO.

Can you please help on how I can achieve this?

Business	Month1	Month2	Month3	Filter
A	1000	500	200	YES
B	5000	70	600	YES
C	100	300	980	NO
D	500	10000	600	YES

[ImadZidan · Accepted solution]

Hello @janani_venkat ,

May be this will give you an idea.

I hope you find it helpful

[janani_venkat]

@ImadZidan

Thank you so much! I was using the sum but was not removing one of the grouping columns (feel like an idiot now!) - thank you so much!