4 Replies Latest reply: Aug 18, 2011 12:03 PM by Tom Nohelty RSS

    chart comparing revenue to budget

      I am new at quickview and need some help.  I am trying to insert a chart that should look like the following has 4 columns(month, budget val, revenue val, variance).  I am able to get the chart to appear with the correct numbers for either the budget val or revenue val but not both.  When I use "budget month" as a dimension then my budget values are correct.  If I use "revenue date" then my revenue numbers are correct.  I have the revenue numbers in one spreadsheet and the budget numbers in another  spreadsheet.  Is there someway to drive the diminsion from a unique date and then have the columns sum based on that value?  Screen shots are attached for a better explanation.Thanks for any help.