getting latest 30 claim from latest month from one year data

[sagarrahul]

hiii community

i am having a problem

i am having a table in that there are two coulm  clm_intimation_date and clm_xgen_num .

i am having data from >=01-Jan-2015 <=31-Jul-2016 and clm_xgen_num of this period  ie 1 year

now what i want is that i want latest month ie july all the clm_xgen_num

how can i get it

can u help me in this

in advance thank you 

[Anil_Babu_Samineni]

Why not this,

Sum({<month = {'july'}>} clm_xgen_num)

OR

If you want to show year 2016

Sum({<month = {'july'}, year = 2016>} clm_xgen_num)

Here month is

Month(datefield) as month

[kumarkp412]

Hi Sagar,

Check this,It will returns the latest month in the data feild as month(datefeild) as month.

Sum({$<Month={$(=Max(Month))}>}[Sales]).

Thanks

Kumar KVP

[sagarrahul]

if i want latest claim of 20 days then