Need a table based on below conditions

[shiveshsingh]

Hi Guys

Need your help here. Please check below table.

Sr. No	Month	DMU Names	Location	A	B	C	D	E
1	AUG	Kerala	India	10	232	23	5
2	AUG	Delhi	India	12	45	2	55	67
3	AUG	Noida	India	26	5	3
4	AUG	Lucknow	India		6			43
5	AUG	Delhi	India	13	67	2	54
6	AUG	Delhi	India		68			23
7	AUG	Lucknow	India	14	6	3		23
8	AUG	Kerala	India	177	23	3	5	98
9	AUG	Noida	India	19	332		54
10	AUG	Kerala	India	20			343	9

Through this table, i need below table

Product	Aug		Benchmark
A	2		30
B	3		30
C	1		30
D	2		30
E	3		30

Here bench mark should be editable and dynamic and logic for getting the values below Month(AUG) is

lets take eg for A, so here '2' signifies the count of DMUs whose sum(A) is greater than benchmark.(Kerala and Noida)

Please help, and i don't have license as of now, so kindly help with the expressions and script as well.