Max Month

[#1]

Please could someone assist me with the max month function - or alternative!

My data looks like this:

SicknessMonth	TargetSickness	ActualSickness
January	3%	1.7%
February	3%	3.5%
March	3%	3.8%
April	3%	2.7%
May	3%
June	3%
July	3%
August	3%
September	3%
October	3%
November	3%
December	3%

My current expression in my guage is =sum(if (SicknessMonth = 'January',  ActualSickness))

This correctly delivers 1.7

However I always want my chart to show the current month - which should be the last entry......

Thanks

Extra attachment for further assistance added 11.05.2015

[#2]

Hi Aaron

Thanks for your help, I have tried your one of your solutions and it seems to sum all of the months values if it does not find a current month.  I like your recommendation but could do with assistance as am very new to this.  I have uploaded my example.

In this, I would always like the current month to default i.e 7%, if not then the previous month 2.7% and so on....

However, if you could guide me in improvements to this, I would be extremely grateful.