I have a requirement where when at week level the numbers are like MTD, so when i drill up it should pick the data against the last week of the month. This is a case for Timestate rollup....But, when i go from months to quarter, the total of all the months is the sum for the quarter. Is it possible
Not in Transformer, unless you use 'externally rolled up measures' But I don't know anyone who has ever done that so I don't recommend it.
You could create two different measures that work in those two different ways, then write a super smart Report Studio report over it. But you won't get that kind of native functionality.
There might by a tricky way of addding these two measures together but I can't think of it right now.