Hi. Need experienced and wise adviser.
I have 3 indicators by date.
I have to mark each by letter by condition.
A: <= 20%*,
B: >20% and <=80%*
C: >80%*
* - accumulation sum sorted by value
I have this:
| Premium | Revenue | Amount | Date | Month | Product |
| 200 | 5000 | 5 | 06.01.2014 | 1 | Product6 |
| 200 | 1000 | 7 | 06.01.2014 | 1 | Product7 |
| 235 | 1550 | 15 | 07.01.2014 | 1 | Product4 |
| 235 | 8000 | 2 | 07.01.2014 | 1 | Product5 |
| 235 | 300 | 1 | 07.01.2014 | 1 | Product7 |
| 550 | 770 | 15 | 01.01.2014 | 1 | Product9 |
| 1550 | 3000 | 14 | 02.01.2014 | 1 | Product10 |
| 2200 | 10000 | 1 | 06.01.2014 | 1 | Product9 |
| 2535 | 12150 | 2 | 07.01.2014 | 1 | Product8 |
And I need this:
| Premium | ABC Premium | Revenue | ABC Revenue | Amount | ABC Amount | Month | Product |
| 235 | C | 1550 | C | 15 | B | 1 | Product4 |
| 550 | C | 770 | C | 16 | A | 1 | Product9 |
| 1550 | B | 3000 | C | 14 | B | 1 | Product10 |
| 200 | C | 1000 | C | 7 | C | 1 | Product7 |
| 200 | C | 5000 | C | 5 | C | 1 | Product6 |
| 2535 | A | 12150 | A | 2 | C | 1 | Product8 |
| 235 | C | 8000 | B | 2 | C | 1 | Product5 |
| 2200 | B | 10000 | B | 1 | C | 1 | Product9 |
| 235 | C | 300 | C | 1 | C | 1 | Product7 |
Have any ideas???
