I have to create a line chart with MonYear and DM as two dimensions. Then the Sum(Calc_Direct_Margin) as the expression.
Here the trickier part is any DM with the name as "Target" has value for only one MonYear. Example, Wave3-Target, Wave4-Target and Wave5-Target has value only for MonYear 'Jul 2016' and does not have any value for rest of the MonYear values.
So the requirement is for only those Target Waves, i have to accumulate the value for the rest of the MonYear. Example: If Wave3-Target value is 319106.4, then for Aug 2016 it should be 319106.4+319106.4, for Sep 2016 it should be319106.4+319106.4+319106.4 and so on (Accumulation).
But for the DM without Target on their names, the expression should be a simple sum(Calc_Direct_Margin).