i have a date heirarchy
dim date
Year
Quarter
Month
and measures SalesVolume
how can i create salesvolume calculated measure for prev quarter, prev 3 quarters and so on.Dear Chilukurisri,
try to use the same logic of the other post and try to use the function QTD too.
Helped?
Regards!
|||thanx pedroCGD, but QTD will give Quarters to date value so if we select the current member then it will give the sum of quarters for all the values starting beginning of the year but what i am looking is for a formula to calculate last 3 quarters irrespective of wheather i select what member in the current year i.e end of the quarter or middle of the quarter. How can i achieve that?
No comments:
Post a Comment