Pareto

[Anonymous]

Hello

I have this Data (attached as a .qvd) and I want to make a "Pareto" where the 20% of the "Solicitantes" represent the 80% of the "Valor Factura". I want to have a bar/line chart and a pivot table.

I'll be glad to have some help!!!

Thanks

[#2]

Hi Juan,

see the attached example and the BUTTON called Pareto (and here the ACTION tab).

Good Luck!

Rainer

[Anonymous]

Ok, that's great. If I want to see the percentages in the table??? one column for the 20% of the "Solicitante" who represents the 80% of the "Valor Factura"???

[#4 · Accepted solution]

Good morning Juan,

here are a modified example.

I hope it supports you to get your numbers.

Good Luck!

Rainer

[Anonymous]

Thanks a lot!!! really!!! it was very helpful!

[#6]

Realy very nice post!.. Tks to Rfa!

[zagzebski]

Rainer -

I saw your example and wondered how can I put a variable in the "percentage" box. Every time I do it doesn't recognize it , but if I put a hard coded number in then it does recognize it. Any help is appreciated!

Steve

[#8]

Steve,

sorry for the delay!

I modifyed the example so that you are now able to set a variable.

Good luck!

Rainer

[zagzebski]

Thanks!