Need last Year

[bharatkishore]

Hello All,

I have a month field where the data is like May-16,Jun-16.

Now my requirement is i need to get last year. For example when i select May-16 i should get May-15.

I have given max(month)-12 but it is converting to integer..like 42479..Can you please help me on this..

Thanks,

Bharat

[antoniotiman · Accepted solution]

See attachment

[bharatkishore]

Thanks a lot Antonio..I don't know where i missed it..Can you please tell me..

[#4]

try like this last year may-15 data

=sum({<DATEFIELD={">$(=Date(addMonths(min(DATEFIELD),-12))<=$(=Date(addmonths(max(DATEFIELD),-12)))"}>}measure)