Results 1 to 2 of 2

How to calculate Actual sales YTD and Forecast for rest of rear in powerpivot

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2020
    Location
    Staesville, United States
    MS-Off Ver
    2019
    Posts
    1

    How to calculate Actual sales YTD and Forecast for rest of rear in powerpivot

    I have several files that I have compiled into power pivot and I am trying to create a formula to give me a Full Year Forecast field that I can use in my pivot table. The Full Year forecast would equal the sum of Actuals for the current calendar date minus 1 month plus the sum of Forecast for the current calendar month and each subsequent month through the remainder of the year.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 02-03-2019, 07:33 PM
  2. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  3. Replies: 0
    Last Post: 04-14-2014, 10:06 PM
  4. Calculate sales forecast using multiple criteria
    By franztupaz in forum Excel General
    Replies: 3
    Last Post: 04-02-2011, 11:45 AM
  5. How To Calculate Variance B/W Actual and Forecast Data
    By Cherish2007 in forum Excel General
    Replies: 1
    Last Post: 03-28-2007, 05:01 PM
  6. [SOLVED] compare forecast to actual sales made, scorecard
    By Joe@GSI in forum Excel General
    Replies: 0
    Last Post: 06-08-2006, 09:20 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