I am trying to create a calculation that will show me last 3 months Qty.
The complex issue here is: I need to sum Qty of 3 month back from the selection Year months
(If no selection is made then Today will be the date)
Attached my qvw File
Note: The period selection could be from either 2 sources : YM field from the table and the Year / Month selection fields on top
Thanks a lot for your time!
Try with this expression
Hope it helps
Thanks Iyyappan, the set date variable is working good but
the calculation is not correct, for example : If I select Jan-2012
I expect to see 0 since there was no Qty in Oct-Dec-2011.
Just use Latest 3 months expression.
The solution looks good though it has an issue:
We have 0 Qty in May-2011, therefore the calculation will show 0 in last 3 months
When removing the condition If(Column(1)>0 ...) then it works.
Please clarify : What is the reason for this condition?