I can't help but think this should be fairly simple; but I'm just having trouble with it.
I have 2 measures.
Actual
Plan
I want to find the % variance.
((actual-plan)\plan) * 100
But when I add this calculation to the cube I get the wrong answer; I'm guessing it's running the calculation on each row then summing the total.
I've taken a look a the roll up types and couldn't find anything that would shift the measure to be calculated rollup - but I might be reading it wrong.
Any hints or points in the right direction would be appreciated.
There is a Rollup tab where you can set it to 'Default (After Rollup)'. I have it this way and it is working. This is my calculation:
( "Net Sales Amt" - "Plan Net Sales Amt" ) / "Plan Net Sales Amt"
The format is set to '0%'