80-20 Analysis : What if as a manager I would like to see the top (20%) customers that contribute (80%) of the ...Partnersfilmexxx.link,sextotal.net,ahmedxnxx.com,https://xnxx1xvideo.com,russianxnxxSkiptocontentHome,ExcelTips80-20(Pareto)AnalysisinExcelPostedonApril24,2017December28,2018byChandeep -  QuickRecapofwhathappenedyesterday!YesterdaywasSunday(23Apr)andIbingedlikeamadman.BlueberryJamCake,SaltedLentils,StuffedPranthas,Beer,Chicken,Ice-Cream,ohyes..andthelunchwasseparate😀ButIburntthisall..How?? IwalkedforanhourinascorchingsummereveningholdingmynotoriousSon(oftenfounddancingonmyhead)Inlessthan20%ofmyday’stime,IburntallthejunkthatIatethroughouttheday.Classicexampleof80-20ruleYou’llfindatonofreallife(business)exampleswhichabidebythe80-20Rule.Let’stakeanexampleofhowwouldyouperform80-20(a.k.aPareto)analysisinExcel ConsiderthisDataset..AsimplesalesdatasetwithTransactionNoCustomerNameRegionofSaleSalesAmount 80-20Analysis:WhatifasamanagerIwouldliketoseethetop(20%)customersthatcontribute(80%)oftheSales.Notethatinmostcasesyouwouldn’tfindthenumberstobeexactly20%or80%butthishasbeentheoreticallycorrect.Inmyoptionthesedaysthenumbersaregettingmoreandmoreskewed,foreg2%ofcustomerthat contributedto95%ofsalesAnywayslet’sseehowcanthisbesolvedinExcelandjusttomakethingsmoreinteresting,IwouldliketoalsofiltertheCustomersbyRegionsaswell(i.e.top20%customersinEast,West,NorthorSouthandOverall) CreateaPivotTable3QuickStepsafteryoucreateaPivotTableDroptheCustomersinRowsDroptheSalesinValuesAndsorttheSalesinthePivotTableinthedescendingorder FindRunningTotalsAddtheSalesinthevaluesonceagain.SumofSaleswillappearagaininthePivotRightClickonSumofSales(2)inthePivotTableandgotoValueFieldSettingsInshowvaluesaspickRunningtotalsin%andapplythatcalculationontheCustomerfieldAndBoomDone! Whatthisis showingyouisthat–howSalesaretotalinguptoa100%and nowyoucaneasilyfindoutwhichcustomerscontributed 80%ofthetotalsales FilterbyRegionusingaSlicerNowit’llbeprettycoolifIcandotheParetoanalysisandsplitthesalescontrib