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.