Previous Months Data

[Anonymous]

Hi All,

Please if any one can help me on the solution.

I need to get the data for the previous months. For Eg:- If year is 2017 and Month selected is April then i should get the count records of (Jan+Feb+March+April). If i click March then it should get the count records of (Jan+Feb+March)

its bit urgent.

Thanks in Advance!!

[Anil_Babu_Samineni]

Just use

Sum({<Month = {'$('<=' & =Max(Month))'}>}Sales)

[Anonymous]

I replaced the Month and Sales with my field, but its giving error.

[Anonymous]

Can anyone help here.