Hi All,
Could you please help me to how to write the express to Calculate the Cumulative Total %?
For example:
Upto 10% has 20 unique material numbers and 14 unique supplier numbers.
upto 20% has 48 unique materials and 25 supplier numbers
upto 30% has 72 unique materials and 42 supplier numbers
etc....
The result:
| Range% |
Total % |
| Upto 10% |
20 unique materials and 14 unique supplier numbers |
| Upto 20% |
68 (48+20) unique materials and 39 (25+14) 100+200) unique suppliers |
| Upto 30% |
140 (72+48+20) unique materials and 81 (42+25+14) unique suppliers |
'
In the Attached file please refer column Q (highlighted in yellow), where the % upto 10 should be categorised as "Upto 10%", anything more than 10% but less that 20% should be categorised as "Upto 20%", anything more than 20% but less than 30% should be categorised as "Upto 30%" etc.... however the Range % should show the result as shown in the table (i.e cumulative).
Please help ASAP.
Regards
Vani
