LinkBack URL
About LinkBacks
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%
Register To Reply
Bookmarks