Pareto expression

[#1]

Hi all,

I'm looking for a way to build a kind of Pareto not as a chart but as an expression

The data I have look like

PRODUCT          SALES

A                         10

B                          20

C                         30

D                         40

E                         60

What i'm looking for is count(product) = 80% of the sales

I konw how to do that with a chart but in an expression...

Any idea?

[Gysbert_Wassenaar]

See here

[#3]

Many thanks Gysbert I was having a look

As I understood it requires the sales to be ordered