Aggregate Size (ClassesABC %)

[#1]

I create classes ABC buyers in size.
Class A should be buyers making 80% of sales, class B buyers making 15% of sales and class C on 5% of sales.
Can you help

ex:

LOAD * INLINE [
Buyer, Sales

jonh, 100
mario, 22
luca, 32
ven, 3
trist, 213
giulia, 21
andrea, 54
manuel, 76
antonio, 76
enrico, 765
fabio, 54
valeria, 43
lino, 98
pino, 5
tino, 4
serio, 3453
];

[miikkaqlick]

Hi!

I don't think it's possible to change dimensions calculations without reloading data. Or I don't know...

Slight improvement for Hèctor's script:

INPUTFIELD A_line;
INPUTFIELD B_line;
//--Snipped some code away --- //
t1:
Load
 *,
 if([Acc. Percentage]<=$(A_line),
 'A',
 if([Acc. Percentage] > $(A_line) AND [Acc. Percentage]< $(B_line),
 'B',
 'C'
 )
 ) as ABC
;

[\code]
This way You can add 2 inputfields to layout and change values from there. You still have to reload application for changes to take effect.

BR,
Miikka</body>

[#3]

Miikka,thank you very much but
The problem is that I can not reloading.

I don't give up