To show the latest Month expression

[prabunakil]

Hi, i have a table to show the net sales.

the table include of field name, transactionmonth1, net sales.

What is the expression in the straight table i can set to show the net sales always show in current month (Latest Month).

eg: now is August, the net sales showing is aug sales. next month is sept, net sales show is september.

Please advise. 

[prabunakil]

this expression put in where?

[Arthur_Fong]

Hi Prabu,

Refer attached is the sample to show the current month in table.

Thanks and regards,

Arthur Fong