could any one of you please help me in writing the expression for finding the Range%.
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) unique suppliers
Upto 30%
140 (72+48+20) unique materials and 81 (42+25+14) unique suppliers
'
In the Attached file please refer column N (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 reply via a screenshot of the expression and not via the QVF/QVD file.
