SSRS: Calculating percent change within a Group in Report Builder
Something that seems like it should be simple, is causing me quite a headache.  I have a table based off an MDX query (simple drag-and-drop from a Cube) and would like to calculate a % increase of values within a group.  

[It won't let me post an image because I'm new, so please see: http://i.imgur.com/o9iJu.png

In the column groups, I have "Metric" and "Year".  I'm trying to get a column to the right of each year, saying, for example, that year 2011 was X% of year 2010.  Every time I try to use a Previous() or Last() function as an expression, it doesn't work.  If someone could let me know how to handle this one without doing some crazy custom MDX query, I'd appreciate it!  


Thanks,

-Adam
SSRS: Calculating percent change within a Group in Report Builder
===

Something that seems like it should be simple, is causing me quite a headache.  I have a table based off an MDX query (simple drag-and-drop from a Cube) and would like to calculate a % increase of values within a group.  

[It won't let me post an image because I'm new, so please see: http://i.imgur.com/o9iJu.png

In the column groups, I have "Metric" and "Year".  I'm trying to get a column to the right of each year, saying, for example, that year 2011 was X% of year 2010.  Every time I try to use a Previous() or Last() function as an expression, it doesn't work.  If someone could let me know how to handle this one without doing some crazy custom MDX query, I'd appreciate it!  


Thanks,

-Adam