Pareto excluding values

Wed, 24 Jul 2013 19:35:34 GMT

Of a total of 257 suppliers totaling 44,711,497,497.29, I would like to calculate the Pareto excluding certain providers.

Example:

If you exclude the supplier "PE0151-PERUANA DE MOLDEADOS,S.A.". I would like to calculate the pareto over 256 suppliers and totaling 1,941,767,337.29.

When calculating the Pareto need to reflect this:

The text object:

"El 7,81% de los proveedores hacen el 80,50% del importe de compras (20 proveedores)",

("The 7.81% of providers do the 80,50% of the amount of purchases (20 suppliers)")

The simple table:

The "%Importe" and "% Acum" should show the 80% and not 100%.

I am attaching the document

Thanks a lot

topic Pareto excluding values in QlikView

Pareto excluding values