Hide Measure Values at certain levels

[ComplexQry]

Many of the measures that I have in a cube I developed cannot be rolled up.  For example, we take a snapshot of # of accounts we have every month.  So if don't do anything and I look at this measure by year, it is duplicating the counts.  The numbers will only show correctly if I get to the month level.  Is there a way to combat this issue in Transformer?

[twlarsen]

You should be able to choose how you aggeregate it in the measures area in transformer.

[ComplexQry]

Sorry, I am not understanding what you mean...

I was hopeful that Time State Rollups would do the trick.  Particularly 'Last' and 'Current'.  But Last won't show a 2010 value until December.  'Current' won't show a 2009 value.  Basically, I just if it is May, I want May to be the 2010 Value.  But I want December 09 to be the 2009 value.  Can this be resolved somehow with special categories?