Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 1 dimension and 2 expressions. I fill in the label of the expressions.
Now i drag/drop the expressions to the left of the chart and the dimension to the top.
So, i have on the side my labels (expressions), two rows, one with let say SUM(value1) and below that SUM(value2).
But now i want to distinct from both value1 and value2 actuals and budgets, plus a comparison to the year before.
I can use set analysis to make the distinction, but i dont see how i can split that in this chart?
i could add a dimension with actual and budget, but that is not sufficient because i also need to compare with 2010
i have added an example..
this is partly what i need .. but now i want to add an expression that adds a comparison
between actual and budget and between actual 2011 and 2010.
i dont mind to create an expression for each team .. but i dont see how to achief this.