• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Producing Top 10 Reports

The 80/20 rule often applies to a business dataset. Perhaps 80% of the revenue comes from 20% of the customers. You may find that beyond the top 10 or 20 customers, the report contains many tiny customers who are just buying a few dollars of repair parts. Your VP of Sales probably has the attention span to look at a one-page report of the top 20 customers, but may ignore a 10-page report with 500 customers on it.

Luckily, pivot tables make it easy to filter the report to the top 5, bottom 10, or any conceivable combination of top or bottom records.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint