Thanks, that could've worked,
but the deal is that I have, say, two separate tables:
MonthA Sales A Jan 1000 Feb 1100 MonthB Sales B Jan 500 Feb 700
I want to have a chart with one dimension and two measures.
First part is easy:
I put MonthA as a Dimension and sum(Sales A) as an expression.
Second part is hard:
Expression is sum(Sales B), but I want the expression to perceive Dimension as not what it is(MonthA), but as MonthB.
(Because it will not perform the calculation, as MonthA and Sales B are simply not connected in the model)
Heh, I doubt if it will solve this problem
In reality the tables are, in fact, connected and look like that:
Phase1ID Phase1Month Phase1Value 1 Jan 1000 2 Feb 1100 Phase2ID Phase1ID Phase2Month Phase2Value 30 1 Feb 500 31 2 Mar 700
And as a result I want a chart which looks like that:
Month Phase1ValueSum Phase2ValueSum Jan 1000 Feb 1100 500 Mar 700
Do you want to set targets by month names? I mean for Jan in Phase1Month you want value from Jan Phase2Month?
If yes,than I suggest to create new table (resident from the second). Use it like this
Left join(<first table>)
Phase2Month as as Phase1Month,
Phase2Value as Target
Resident <second table>;
And it will work