Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is this possible? (In my opinion it's not very useful since the budget amounts are stacked; not 0-based (except for Q1); i.e. hard to compare Q2 to Q2. But it's what the client wants)
Bar Chart - Budget and Actual as Grouped - Sliced by Quarter - Google Drawings
Hi.
Yes it's possible. Assuming that you have Actual and Budget measures as different fields you can do the following.
Create a stacked bar chart with three dimensions:
Division
ValueList('Budget','Actual')
Quarter
And add the expression:
if(ValueList('Budget','Actual')='Actual', Sum (Actual), Sum (Budget))
Choose empty (space symbol) label for the ValueList('Budget','Actual') dimension.
Hi.
Yes it's possible. Assuming that you have Actual and Budget measures as different fields you can do the following.
Create a stacked bar chart with three dimensions:
Division
ValueList('Budget','Actual')
Quarter
And add the expression:
if(ValueList('Budget','Actual')='Actual', Sum (Actual), Sum (Budget))
Choose empty (space symbol) label for the ValueList('Budget','Actual') dimension.