Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
The Cummulative column not exist in my final project. it's only for my example.
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.
These might help you
Recipe for a Pareto Analysis – Revisited
hi,
have a look at the attached sample
hope this helps
Hi Frank,
that's right. But if the data is not sorted at loading ?
How to add sorting to expression.
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