MRSware CRM Sales Commissions
  • Home / Links
    • MRSweb Login
    • MRSware Sync
    • Webmail
    • Spam Filter Portal
    • LinkedIn: EYOND, Inc.
    • Twitter: @eyondinc
    • About
    • FAQs
  • Sales & Commissions
    • Sales Reps
    • Manufacturers
  • CRM
  • Integrations
  • Blog
  • Pricing
  • Try It
  • Support
    • Training Classes - MRSware >
      • Lesson 1 - MRSware Home Page
      • Lesson 2 - CRM - Companies/Contacts
      • Lesson 3 - CRM - Calendar
      • Lesson 4 - CRM - Journals
      • Lesson 5 - CRM - Tasks
      • Lesson 6 - CRM - Projects
      • Lesson 7 - MREPS - Customers
    • Training Classes - MRSweb
    • Documentation
    • Admins
    • Live Service Status

Principal Ranking - % of Total Sales or Total Commissions

7/12/2012

0 Comments

 
​Our customers often ask how they can find out what each line represents, as a percentage of their total sales or total commissions.  For instance, the agency represents 10 lines.  Which lines are the most important - sales wise and commission wise?  

In the old days we had to set up an Excel file and enter the total sales and the total commissions for each line and then sort by sales or by commissions to find out which lines were the largest.  You would have to enter a formula into Excel in order to find out the actual percentage of total sales or total commissions each line represented.
​
Now all you have to do is use MRSware's Data Analysis "Sales and Commission Analysis" to get this information.  If you have entered your sales and commissions into MRSware the analysis cube will automatically formulate the information for you.  All you have to do is click a couple of buttons to see the results.
Here's how:
​


1 - Click on "Data Analysis" in the Shortcuts panel or the "Data Analysis" icon on the Shortcuts Tool bar



Picture
Picture


​2 - Select the "Sales and Commission Analysis"


​

3 - Select the dates you want to look at in the Parameters dialog

 In the example we selected the first quarter of 2012.










​

Picture
Picture


​4 - Click on "Summary Settings"




​







​
5 - Check or Uncheck the boxes you want to include in the analysis

In the example we unchecked Agency Split Commission & Sales Rep Split Commission.






​
6 - When done, click "Ok"

​


​
Picture
Picture

7 - Hold down the left mouse button, click on "Principal", and drag "Principal" above "Customer".  Release the left mouse button to place "Principal" at the top of the list.  

​The list should read (top to bottom) "Principal", "Customer", "Product".




​

8 - To view the Principals with the most sales top down, click on "Agg. value" under the Sales column




​


​
Picture
Picture




9 - To view the Principals with the most commissions top down, click on "Agg. value" under the Commission column



​


​

​



10 - To view what percentage each Principal is of total sales, right-click on "Sum" under the Sales column and select "% Col".  ​








​

Picture
Picture




​To view the results top down, double-click "% COL" - Heavenmade has the largest % of total sales, followed by California Custom





​



11 - To view what percentage each Principal is of total commission, right-click on "Sum" under the Commission column and select "% COL"





​
​
Picture
Picture




To view the results top down, double-click "% COL" - Heavenmade has the largest % of total commissions followed by California Custom 


​It's always a good idea to check % COL for both Sales and Commission in the analysis because a Principal may not have the same ranking in sales as they do in commission.  

In the examples used above - 1st quarter of 2012 - the Principals have the same ranking for sales and commissions. However, this may not always be the case.  

​For example, if a line that has a smaller sales dollar volume pays a higher commission rate, then that line may have a larger commission dollar volume than another line that has a larger sales dollar volume but pays a lower commission rate.    

0 Comments



Leave a Reply.

    Documentation

    ​You will find technical documentation, MRSware instructions, release notes, and general content to help MRSware users through their day on this page.

    Please use the Categories below to find documentation for each area in MRSware.

    ​You may also use the Search field above to look for specific topics. To get a more precise list of articles for a particular menu option, for example, use quotation marks around the text in the Search box, e.g. "bulk assign sales rep".

    Categories

    All
    1
    Appointments
    Auto-Complete
    Categories
    Data Analysis
    Duplicate Removal
    Education Module
    Email
    Email/Spam
    Email Templates
    File Share
    Google
    Installation
    Master List
    Microsoft Office
    Mobile
    (MREPS)
    New MRSware Users
    Outlook
    Projects
    Reports/data Analysis
    RSS Reader
    Sales Force Automation (SFA)
    Search / Filter / Sort
    Sync
    Tables / Listings
    Troubleshooting
    User Manuals
    Video

    Archives

    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    September 2019
    April 2019
    September 2018
    January 2018
    August 2017
    February 2017
    January 2017
    December 2016
    September 2016
    July 2016
    June 2016
    May 2016
    February 2016
    January 2016
    December 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    July 2014
    June 2014
    February 2014
    October 2013
    September 2013
    July 2013
    May 2013
    April 2013
    March 2013
    February 2013
    November 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    May 2011
    April 2011
    March 2011
    December 2010
    September 2010
    July 2010
    May 2010
    April 2010
    February 2010
    January 2010
    December 2009
    November 2009
    October 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    October 2008
    September 2008
    August 2008
    July 2008
    June 2008
    May 2008
    April 2007
    September 2006
    August 2006
    July 2006
    June 2006
    May 2006

    RSS Feed

sales@MRSware.com     (866)795-8386 x1   ​
Copyright (c) 2002-2021 EYOND, Inc
.
MRSware is an EYOND, Inc. Integrated Solution
Austin, TX  USA