What seems to be like a very simple request/idea, also seems to be impossible to do in Transformer.
I have a measure, Days in Month.... it is just way it says.
But the rollup depends on timestate obviously.
If I'm rolling up on the time dimension, I want to SUM.
If I'm rolling up on any other dimension, I want to average/max/min (it'll all return the same)
Unfortunately, in Transformer, for whatever reason, SUM is not an option for Timestate roll-up.
Any idea why?
Any thoughts on how I can get around this?
Pinned topic Transformer - Days in Month - Rollup
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-04T16:59:26Z at 2013-01-04T16:59:26Z by KevinSlanicky
KevinSlanicky 270003A1AR5 Posts
Re: Transformer - Days in Month - Rollup2013-01-04T16:59:26ZThis is the accepted answer. This is the accepted answer.
- yangling 0600018QDQ
Surely I'm not the only one who's ever needed to SUM across the time dimension, but AVERAGE across a regular dimension, am i??