number of customer who makes 80% of turnover

[fredericmante]

hi all,

i need your help
I would like to display in a text object, the number of customer who makes 80% of turnover.

Thanks in advance for your help

Fred

[fheidenstecker]

Hi there,

i had a look at your examples for the pareto analysis. These are some very usefull examples. I just wante to ask if any of you has an idea how to display this kind of information in a chart?

I want it to look something like this example graph

http://www.dhl-discoverlogistics.com/dhl/logistikkurs/img/de/chapter_04/4.3.3_Selektive_Lagerhaltung...

The x axis should show the percenteage of customers cumulating up to 100 %, the y axis should show cumulated revenue up to 100 %. I am not even sure what chart to use, i am wondering if i need a matrix chart, but with lines and not dots???

Thanx for suggestions,

Fabian

[#3]

Hi There,

In John's qvw file, the figure that is shown is given for the table sorted by weeks.

Does anyone know how to report the figure when the sorting parameter is on the Amount field (descending or ascending).

The goal is to report the value in a text field that would state:

i.e 80% of the aggregated 'field' Amount is concentrated in 4 'weeks' regardless when the weeks happen.

Thanks

Gerard

[#4]

First of all thanks to all usefull approach,

I'm having the same problem with counting occurence in a textbox and i would like to know if someone have come up with a solution to the sorting problem.

Thanks.

Marco.

[diego_alegre_nu]

Hi John,

Any solution after so much time. I am stuck right in the same point.

THNX,

[yblake]

After so much time, the solution came from R&D : The sortable Aggr function is finally here!

[diego_alegre_nu]

Thank you Yves! Great!