Hello, In my cube, in the measures section I have an Revenue-Actual and Revenue-Target measure that come from seperate data sources. Within each data source is a Source Indentifier (1 is Actual, 2 is Target) which I then use as a dimension.
I would like to know if I can one measure for the above (Actual and Target together), so in report studio I can bring this new one measure as a row and place the dimension in the columns, so it would split out the values by source type.
I have attached an example to illustrate this?
Thanks in advance.