+ Reply to Thread
Results 1 to 1 of 1

Determining how many customers make up 90% of a sales person's budget, for a list of 2000

Hybrid View

  1. #1
    Registered User
    Join Date
    11-21-2014
    Location
    Saint Louis, MO
    MS-Off Ver
    2010
    Posts
    1

    Determining how many customers make up 90% of a sales person's budget, for a list of 2000

    I've a spreadsheet of every customer # and their revenue YTD for 2000+ sales people. I've been asked to figure out the number of customers, by salesperson, equals 90% of their revenue. I pivoted the data listing the revenue by customer # in descending order in the first column and a second column that shows the running total. I can do a countif statement to determine what I need to do, but don't want to do that 2000+ times....any ideas?

    Row Labels	Sum of Total GM YTD	Sum of Total GM YTD3	0.90
    99	331634		34
    170985	33411	10.07%	
    171831	28372	18.63%	
    450926	26209	26.53%	
    173231	20268	32.64%	
    354535	15534	37.33%	
    172085	13506	41.40%	
    174976	11873	44.98%	
    169483	11496	48.45%	
    169325	10771	51.70%	
    170683	9833	54.66%	
    170950	9551	57.54%	
    171935	9502	60.41%	
    492485	9402	63.24%	
    169369	9366	66.06%	
    328111	7994	68.48%	
    169443	7321	70.68%	
    424411	6525	72.65%	
    173572	6249	74.53%	
    174670	4628	75.93%	
    169496	4271	77.22%	
    170663	4041	78.44%	
    485345	3627	79.53%	
    173862	3611	80.62%	
    174576	3499	81.67%	
    501702	3404	82.70%	
    171543	3330	83.70%	
    171765	3155	84.66%	
    486030	3102	85.59%	
    173525	3035	86.51%	
    170770	2210	87.17%	
    169387	2165	87.83%	
    171027	2161	88.48%	
    171947	2088	89.11%	
    170721	2078	89.73%	
    517685	2044	90.35%	
    341556	1870	90.91%	
    169903	1831	91.47%	
    171842	1804	92.01%	
    170060	1794	92.55%	
    357562	1693	93.06%	
    171707	1679	93.57%	
    367398	1576	94.04%	
    171875	1433	94.48%	
    325861	1428	94.91%	
    171237	1345	95.31%	
    169911	1330	95.71%	
    172316	1255	96.09%	
    172099	1202	96.45%	
    163620	1127	96.79%	
    169816	1087	97.12%	
    171279	1073	97.44%	
    172385	975	97.74%	
    172506	885	98.01%	
    430848	809	98.25%	
    330834	682	98.45%	
    225663	627	98.64%	
    172698	623	98.83%	
    338213	593	99.01%	
    174592	573	99.18%	
    173226	544	99.35%	
    174207	426	99.48%	
    508986	375	99.59%	
    357945	322	99.69%	
    172834	284	99.77%	
    492755	210	99.84%	
    174914	152	99.88%	
    426110	108	99.91%	
    170223	99	99.94%	
    438205	99	99.97%	
    506187	65	99.99%	
    173066	24	100.00%	
    509333		100.00%	
    169394	0	100.00%	
    174061		100.00%	
    422584		100.00%	
    462086		100.00%	
    173829	0	100.00%	
    174598	0	100.00%	
    408342	0	100.00%	
    172524	0	100.00%
    Last edited by JBeaucaire; 11-22-2014 at 03:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] List total sales by region, person or date - Possible VLOOKUP solution?
    By dvs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2014, 08:52 AM
  2. Replies: 5
    Last Post: 06-12-2013, 04:58 PM
  3. [SOLVED] Calculate total sales adjustments for each sales person
    By Adama in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-02-2012, 06:26 PM
  4. Divide Monthly Sales Budget to Day budget
    By Benedikt Fridbjornsson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2006, 03:25 PM
  5. Divide Monthly Sales Budget to Day Budget
    By Benedikt Fridbjornsson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2006, 11:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1