+ Reply to Thread
Results 1 to 3 of 3

Get variance between Forecast and Actual using Pivot Table

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Get variance between Forecast and Actual using Pivot Table

    Hello everyone -

    How do I get the difference between forecast and actual in my report using pivot table? I tried "Difference From" but to no avail.

    Also, I would like to put some conditional formatting (RAG status) in weekly total of each project. Is that possible?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    397

    Re: Get variance between Forecast and Actual using Pivot Table

    Hello,
    Try to change the layout of data
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Re: Get variance between Forecast and Actual using Pivot Table

    I liked your output it meets my requirement. just a question, where i can find the "VTF" shown in the Pivot table?

    Also, I want to get the USD value of Actual and Forecast by multiplying the hrs against the billing rate and get the variance in USD too.

+ 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. day on day variance comparison using pivot table
    By yelllowsubmarine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2015, 09:44 PM
  2. Forecast Variance and Percent - need help with hours forecast
    By hoppythyme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2013, 11:15 AM
  3. Forecast Variance and Percent - need help with hours forecast
    By hoppythyme in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2013, 08:37 PM
  4. Pivot Table - Variance Row?
    By davidskg in forum Excel General
    Replies: 0
    Last Post: 02-01-2012, 02:18 PM
  5. Pivot Table issue --variance columns
    By klopeks in forum Excel General
    Replies: 1
    Last Post: 10-05-2011, 12:35 PM
  6. 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
  7. Pivot Table Subtotals/Variance Analysis
    By NCW in forum Excel General
    Replies: 1
    Last Post: 08-06-2005, 03:05 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