4 Replies Latest reply: Jul 7, 2014 3:39 AM by Дмитрий Кудревич

# ABC marks by accumulation condition in table

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???

• ###### Re: ABC marks by accumulation condition in table

Accumulating per product?

And what does the percentage indicate (what are you dividing)? Or does the percentage represent the accumulation per product to the total value of each metric per product?