How to find value (count) for the latest month ?

[MDC]

I want to get latest month's 'Count' from 'Month' column where month is given in below format(YYYYMM):

Month           
201912
201910
202002
202003            

Count
30
20
10
50

[martinpohl]

sum({<Month={$(=max(Month))}>}Count)

Regards

[MDC]

Thanks for the reply Martin.

It didn't  work. As the Month column has the data
in 6 digits numeric format where i need to seperate both the year value and month value, and select the maximum of both of those values.

Can you help?

[martinpohl]

Your response I did not understand 202003 is greather than 201912.....

But

sum({<Year={$(=max(Year))}, Month = {$(=max({<Year={$(=max(Year))}>}Month))}>}Count)