MRSware Sales and Commissions
  • MRSware
    • About
  • Sales & Commissions
    • Sales Reps
    • Manufacturers
  • CRM
  • Blog
  • Pricing
  • Support
    • Training >
      • Training Classes - MRSweb
      • 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
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Login
  • Free Trial

Now Showing: Sales Summary Analysis and the magical 5 columns

11/3/2011

0 Comments

 
Data Analysis

The most requested sales dollar summary fields from the Customer Sales by Rep and Principal Sales by Rep reports can now be found in a new Data Analysis cube titled Sales Summary Analysis.  How to run the data analysis cube:
  1. Open Data Analysis via the Shortcuts panel. 
  2. Run the Sales Summary Analysis cube by double-clicking on it. 
  3. Select the dates to analyze.

Why use Data Analysis instead of the Report Explorer?


​The reports in report explorer are great for quickly generating sales data for print or e-mail; the PDF formatting in particular lends itself well for either of these jobs.  Data Analysis allows users the additional flexibility to sort and filter the sales data to see just what the user is interested in.  For example, a sales rep could filter the cube view to show just a particular customer and the lines he is buying from in order to share this information with the customer.
How to Sort

To sort a column, click the Agg. Value column header.  Clicking once sorts ascending (bottom up dollar amounts); clicking twice sorts descending (top down); clicking a third time will remove the sorting from the column.

How to Filter

On the Dimension fields, click on the "tree" icon to open the filtering dialog.  By default, all members of a dimension are selected; to change the members that are showing, un-check them from the list.  To remove all members, press the red-X button; then re-select just the members you would like to add back in.

​Another advantage of the Sales Summary Analysis cube over a report is the ability to break down the information by additional criteria by using the Dimensions available in the cube.  For example, by including the Address dimension in the left-hand pane, the user can show a breakdown by State of Customer sales.

In order to assist users in getting started using this new Data Analysis cube, we have included several views for download that replicate the layout found in some of the reports available in Report Explorer:

SalesSummary - 
CustomerSalesbyRep.cbs

SalesSummary -
​CustomerSalesbyRep_wPrincipals.cbs

SalesSummary -
PrincipalSalesbyRep.cbs

​SalesSummary -
PrincipalSalesbyRep_wCustomers.cbs

​SalesSummary -
​StatebySalesRep.cbs

SalesSummary -
​StatebySalesRep_monthly.cbs

​Customer Sales by each Sales Rep


​Customer Sales showing each line purchased (Principal) by the Customer, broken down by Sales Rep

Principal Sales by each Sales Rep


​Principal Sales showing each Customer purchasing from the Principal, broken down by Sales Rep

​Sales by State for each Sales Rep; expand the State column to see each Customer for each State

​Sales by State for each Sales Rep shown by month of the year

To use these views:
  1. Download this zip file, which contains all the views: SalesSummary-SavedViews.zip
  2. Open the zip file and extract them to your My MRSware Documents\DataAnalysis folder (defaultly located in the user's My Documents folder).
  3. From within the Sales Summary Analysis cube, use the File à Open menu. Under Files of type: select Cube State File (*.cbs) and navigate to the saved files you just downloaded. Select and click Open on the view you wish to use. The view will be applied to the user's current data set, rearranging the columns and rows to match those saved in the Cube State File.


Column Definitions

This Month
This column shows the sales total for the month selected in the To field.  For example, selecting From 7/1/2005 and To 6/30/2006 will result in this column showing total sales for June 2006.

Prev.YR Month
This column shows the sales total for the month one year prior (year-1) to the month selected in the To field.  For example, selecting From 7/1/2005 and To 6/30/2006 will result in this column showing total sales for June 2005.

This Year
This column shows the sales total for the date range selected starting from the From date and ending with the To date, inclusive of those days.  For example, selecting From 7/1/2005 and To 6/30/2006 will result in this column showing total sales for July 2005 through June 2006.

Prev. Year
This column shows the sales total for one year prior (year-1) to the date range selected starting from the From date and ending with the To date, inclusive of those days.  For example, selecting From 7/1/2005 and To 6/30/2006 will result in this column showing total sales for July 2004 through June 2005.

Prev.YR Total
This column shows the sales total for the year prior (year-1) to the year selected in the To date.  For example, selecting From 7/1/2005 and To 6/30/2006 will result in this column showing total sales for year 2005.

Mo.% Diff
This column shows the percentage change from the Prev.Yr Month column to the This Month column as a percentage of growth from previous month to current month.  For example: for Prev.Yr Month = $400.00 and This Month = $600.00, Mo.% Diff = 50; there is a 50% growth from month to month.

Yr.% Diff
This column shows the percentage change from the Prev.Year column to the This Year column as a percentage of growth from previous year to current year.  For example: for PrevYear = $400.00 and This Year = $600.00, Yr.% Diff = 50; there is a 50% growth from year to year.

Date Selection Notes
Select the date range you wish to analyze.  The matching date range for one year prior will be automatically selected as part of the analysis.  For example, selecting a From date of 1/1/2006 and a To date of 6/30/2006 will acquire all of the invoice sales information for 1/1/2005 (the year prior) through 6/30/2006 (the To date) for analysis.
The month selected in the To date field will be the month that is shown in the This Month and Prev.YR Month columns.  Selecting an ending month for which data has not been entered into the system yet, will result in these two columns showing N/A for all entries.
​

Additional Columns
There are three additional columns that are off by default, but can be turned on for additional analysis:
YTD
This column shows the year to date sales dollars for the year selected in the To field.
Prev.YTD
This column shows the year to date sales dollars for the year immediately prior (year-1) for the year selected in the To field.
YTD% Diff
This column shows the percentage change between the YTD and Prev.YTD columns as a percentage of growth from previous year to current year.  For example: for Prev. YTD = $400.00 and YTD = $600.00, YTD% Diff = 50; there is a 50% growth from year to year.
0 Comments

Your comment will be posted after it is approved.


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
    Android
    Appointments
    Auto-Complete
    Batch Edit/Bulk Update
    Categories
    Contacts
    Customers
    Data Analysis
    Duplicate Removal
    Education Module
    Email
    Email/Spam
    Email Templates
    File Share
    Google
    Hidden
    IMAP
    Installation
    Journals
    Master List
    Microsoft Office
    Mobile
    (MREPS)
    MRSweb
    New MRSware Users
    Outlook
    Payments
    Projects
    Reports/data Analysis
    RSS Reader
    Sales Force Automation (SFA)
    Search / Filter / Sort
    Sync
    Tables / Listings
    Troubleshooting
    Types
    User Manuals
    Video

    Archives

    November 2022
    September 2022
    June 2022
    March 2022
    February 2022
    January 2022
    December 2021
    May 2021
    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

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
sales@MRSware.com     (866)795-8386 x1
Copyright (c) 2002-2023 EYOND, Inc
.
MRSware is an EYOND, Inc. Integrated Solution
made in Austin, TX  USA