ABC marks by accumulation condition in table

[#1]

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

[vgutkovsky]

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?

Vlad

[Anonymous]

something like attached? modify the expression for ABC Premium (i just used an example expression) and add other expressions for other ABC fields.

[#4]

For understand task try this:

[#5]

At first need to sort Products by *sum(Amount) and calculate sum(Amount) by Full Accumulation then looking for result marks ABC.