Hi. I'd like to display same year calc'd measures [January Completions], [February Completions] ...[December Completions] next to the [Actual Completions] measure for transaction year x, transaction month y.
If y is January then [January Completions] thru [December Completions] need to be overridden with zeros. If y is February, Feb thru Dec need to be overridden with zeros and so on.
I started experimenting with the query you see below before transferring the logic to my cube. I didnt even get to the if/then logic before I saw that April and beyond of each year's [January Completions] was null. But the correct/same Jan
amount showed next to the 1st 3 [Actual Completions] for 2009 and 2010 which are the only years I've loaded at this point.
[Actual Completions] itself is a calc'd measure from two different measure groups that share most dims including transaction date. I dragged the hierarchical month name to the "on rows" clause. I had no luck mixing hierarchical names with the
currentmember function in the "with" clause so I dragged the non hierarchical tran date names there. What am I doing wrong?
member [Overall Jan Completions This Year]
View Complete Post