+ Reply to Thread
Results 1 to 2 of 2

Show Budget OR Actual sales

  1. #1
    Registered User
    Join Date
    04-07-2011
    Location
    Montreal
    MS-Off Ver
    Excel 2010
    Posts
    11

    Show Budget OR Actual sales

    Hello,

    In my data I have two DataSets, Actual and Budget. Actual sales net of rebates are calculated in a Measure called 'Sales NET of Rebates Actual' and another Measure calculates the budgeted sales NET of rebates called 'Sales NET of Rebates Budget'.

    The difficulty I have is to create a third calculated measure that would show either 'Sales NET of Rebates Actual' or 'Sales NET of Rebates Budget' depending on the DataSet viewed.

    Any help would be appreciated.

    thank you

    Radovan

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: Show Budget OR Actual sales

    Need to see it to know what you are referring to. Post a sample work book, please.
    Click * below if this answer helped

+ 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. Actual as a % of Budget formula
    By nier06 in forum Excel General
    Replies: 1
    Last Post: 02-13-2012, 01:19 PM
  2. Divide Monthly Sales Budget to Day budget
    By Benedikt Fridbjornsson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2006, 03:25 PM
  3. [SOLVED] Divide Monthly Sales Budget to Day Budget
    By Benedikt Fridbjornsson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2006, 11:45 AM
  4. Budget vs. Actual
    By Stanley in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 05:10 PM
  5. [SOLVED] Comparing actual spends against a budget
    By Tracey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-16-2005, 07:05 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