I have an expression for calculating the 3 months average from the selected month.
Suppose if Aug 2012 is selected then it would sum up June,July, August sales.
but when i introduce the Date ( MM/DD/YYYY) format as the dimension then it doesnt seem to work.
It only does the sum of current month.
I use the xpression sum({<Month Name={$v(Date)}>}sales) where vDate =Aug,Jul,Jun if the selected month is Aug.
this expression works well till no date field is introduced as dimension .
On addition of date field
suppose if
Aug Sales=30
Jul=20
Jun=10 then instead of showing 60 it shows 30 only .