How to display max month sales

[niranjan_capgemnini]

Hi experts,

  I struck in one place , my requirement is chart has to be display max month sales that some time current month sales is zero then it has to be displayed previous month sales.

if the previous month and current month sales is zero  then it has to be displayed last to last month sales like that it has to be show.

please guide me how to do this .

below formula i am using 

if((sum({<Year = {'$(=max(Year))'},[Month]={'$(=max([Month]))'},Status={'F'}>}Stock))=0,

sum({$<Year = {'$(=max(Year))'},Status={'F'}>}Stock),

sum({$<Year = {'$(=max(Year))'},[Month]={'$(=max([Month]))'},Status={'F'}>}Stock)

)

thanks in advanced 

[vikasmahajan]

Please check if you require same.

Vikas

[niranjan_capgemnini]

Hi,
Please give any suggestion.
thanks in advance..........