pareto financial analysis

  1. E

    PowerPivot - % of SKUs required to get to 80% of Revenue

    I have been searching for a solution to my problem for the better part of a day, so I thought I would post here hoping someone could help me out. Let me first start with the question I am trying to answer: What percentage of SKUs does it take to reach 80% of revenue. Here is a simplified chart...
    • eliwaite
    • Thread
    • 80/20 pareto financial analysis powerpivot question revenue
    • Replies: 9
    • Forum: Power Tools
  2. S

    Pareta - 20/80 rule to create pivot table

    Hi. I would appreciate some help on getting a formula. I've searched and tested all I could find but all the examples do not achieve what I'm attempting. Here's the image of what I'm searching: In other words, where I made a pivot table of this, I want to get Top 20: 2 people Medium: 10...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top