Closed Thread
Results 1 to 2 of 2

Using sales objectives to calculate daily sales rates by month

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    My cube
    MS-Off Ver
    2016
    Posts
    16

    Question Using sales objectives to calculate daily sales rates by month

    Attached is my workbook – I am currently trying to use sales objectives to establish a ‘daily sales rate’ objective for each month, by region, using the # of selling days per month.

    The ‘daily sales rates’ for each month (by region) for last year are highlighted in blue – and I’m trying to fill in the yellow cells.

    Please note how the values in green are calculated (beginning in cell O39). I’m hoping to use my objectives highlighted in orange to reverse this process and fill in the yellow cells. I know that solely doing this could result in countless solutions but since I have the % increase by region (D7:D18) I think there may be a way to logically work this out.

    Thank you in advance for your input.
    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 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Using sales objectives to calculate daily sales rates by month

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    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

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 12-07-2015, 09:22 AM
  2. Replies: 2
    Last Post: 09-01-2015, 12:43 PM
  3. [SOLVED] Making Daily Sales Planner recognize which month and which week to pull sales data from
    By Topher53180 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 10:33 AM
  4. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  5. Replies: 2
    Last Post: 10-17-2013, 11:52 AM
  6. summarize monthly sales from daily sales
    By top1 in forum Excel General
    Replies: 4
    Last Post: 01-05-2010, 11:59 PM
  7. [SOLVED] cumulating by adding previous sales to daily sales
    By kish_gv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2007, 03:38 AM

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