+ Reply to Thread
Results 1 to 2 of 2

is the sales incentive working?

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    is the sales incentive working?

    One the attached, you will see customer sales data. What i have noticed is customers typically buy the same dollar amount in week 1 of Q1 when compared to week 1 of Q2. My management is piloting new sales promotions in Q2 for four customers to see if a larger iniative would help increase sales and help the company get out of the stagnant cycle they are in.

    For each customer, my management would like to know whether the promotions in Q2 appear to be effective when compared to data from Q1. Analysis should be performed at the weekly level for better insights into when each customer responded to the promotion (if applicable).

    Any and all help is much appreciated!
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: is the sales incentive working?

    A Pivot table would do this for you. The questions you need to answer is what fields in the raw data are you interested in.

    See the attached sample PT which compares sales(qty) by Qtr by Customer by week and filtered by Brand.

    Excel 2016 (Windows) 32 bit
    L
    M
    N
    O
    1
    Brand_ID 01-00077
    2
    3
    Sum of QuantitySold
    4
    MA-6693 Q1 2017
    8
    12
    5
    Q2 2017
    9
    12
    6
    ME-6399 Q1 2017
    8
    12
    7
    Q2 2017
    13
    12
    8
    Sheet: Sheet1
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Formula To Capture Incentive for Sales Goals Met
    By tylermprice in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2020, 05:44 AM
  2. [SOLVED] Sales Incentive Data
    By u_bedi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2018, 03:17 PM
  3. [SOLVED] How to identify whether a Sales is Cash Sales or Credit Sales
    By purav82 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-28-2018, 10:11 AM
  4. IF Function for calculating Sales Incentive
    By pranjal79 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2016, 04:27 AM
  5. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  6. Incentive Forumla
    By bhager in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 05:56 PM
  7. Incentive Forumla
    By bhager in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2013, 01:08 PM

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