Need help creating 20/80 Pareto Principle with just Formulas

[desibouy]

Hello,

While I understand what 20/80 means (20% of Sales, which brings 80% of the business). I've never used this in any of my past works so I have no idea how to do this and what the terms I need.

I've been scouring the web and can't find an answer for this - everyone is talking about pivot charts and adding some kind of % of running totals. I'm not really sure if that's what I need.


The reason why I want this in Formula's is that we use a CRM/ERP software and it uses a different form of Oracle, so if I get in Formula form - I can hopefully convert it into that form.


I came across this site (https://www.mrexcel.com/archive/formulas/create-80-20-rule/) but I couldn't get the example working too many errors. I apologize in advance if I can't post 3rd party links but I checked the forum rules at the bottom (didn't mention anything.

Example of file would be like this

Parent Internal ID	Internal ID	Item Code	Display Name	2017 Sales	QTY Sold
860	868	832100/EA	Bed Rail	77,191.65	638
487	487	Misc Item	Misc Item	49,131.52	2902
1728	17308	HJFC56001BK	Hand Cane	27,267.00	183

<tbody>
</tbody>

 

[desibouy]

Bump.

I really need this report urgently. Please me