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

[TABLE="width: 800, align: left"]
<tbody>[TR]
[TD]Parent Internal ID[/TD]
[TD]Internal ID[/TD]
[TD]Item Code[/TD]
[TD]Display Name[/TD]
[TD]2017 Sales[/TD]
[TD]QTY Sold[/TD]
[/TR]
[TR]
[TD]860[/TD]
[TD]868[/TD]
[TD]832100/EA[/TD]
[TD]Bed Rail[/TD]
[TD]77,191.65[/TD]
[TD]638[/TD]
[/TR]
[TR]
[TD]487[/TD]
[TD]487[/TD]
[TD]Misc Item[/TD]
[TD]Misc Item[/TD]
[TD]49,131.52[/TD]
[TD]2902[/TD]
[/TR]
[TR]
[TD]1728[/TD]
[TD]17308[/TD]
[TD]HJFC56001BK[/TD]
[TD]Hand Cane[/TD]
[TD]27,267.00[/TD]
[TD]183[/TD]
[/TR]
</tbody>[/TABLE]

 

[desibouy]

Bump.

I really need this report urgently. Please me