In my model, I am trying to display TTM for EBITDA. I currently have Sep 2013 selected and when I create an object and have the following expression in the the text box, I get the correct results. The results I get is sum of EBITDA for the current month and the last 11months.
=sum({<Scenario={'ACTUAL'} ,$(sTTM)>}[EBITDA])
However, when I place this same expression in a chart, with Month as a dimension, I am only getting EBITDA for the current month. I actually would like to get the EBITDA for the current month and the last 11 months.
Here is my expression for the point in time for sTTM :