how do i privot this?

amien — Tue, 14 Jun 2011 15:40:13 GMT

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

Re: how do i privot this?

amien — Wed, 15 Jun 2011 12:05:05 GMT

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.