Count customer with cumulative amount

[tgumbing]

Hi,

How to calculate the number of customer which make 80% of the total amount.

How to calculate the number of customer which make between 80 and 95% of the annual amount.

...

With the result in a text object.

The Data : The Customers are classified by amount

Thanks

Thomas

[goro2010]

Good Day, if you have 2 expressions in Sum, then you can make another expression to say coloumb(2)/coloumb(1), then you can just add to your color filter to be green anything above 0.8 as a numeric number.

[tgumbing]

Hi,

The Cummulative column not exist in my final project. it's only for my example.

[tgumbing]

I want this in a text object:

3 Customers how have 80% of the total amount.

1 Customers between 80 and 95% of the annual amount.

4 Customers with less than 95% of the annual amount.

1 with 0 annual amount.

[jonathandienst]

These might help you

Recipe for a Pareto Analysis

Recipe for a Pareto Analysis – Revisited

[Frank_Hartmann]

hi,

have a look at the attached sample

hope this helps

[tgumbing]

Hi Frank,

that's right. But if the data is not sorted at loading  ?

How to add sorting to expression.

[Frank_Hartmann]

then you will have to follow these steps in script:

1. Make a resident load of your Inline table with an order by statement.

2. Load this resident table into a qvd file. Drop the other tables.

3. Load the qvd file.

see attached sample.

hope this helps