Hi All, I have a set of data and where i need to filter it for last 12months can someone help on this. and also, it should act as a dynamic filter. For Example: current month is 08.2018 then it should filter data from 08.2017 to 07.2018 below is my scenario. Input ConsCalendar MonthA08.2018A07.2018A06.2018A05.2018A04.2018A03.2018A02.2018A01.2018A12.2017A11.2017A10.2017A09.2017A08.2017A01.2016C03.2018C02.2018C01.2018C12.2017C11.2017C10.2016 out put ConsCalendar MonthA07.2018A06.2018A05.2018A04.2018A03.2018A02.2018A01.2018A12.2017A11.2017A10.2017A09.2017A08.2017C03.2018C02.2018C01.2018C12.2017C11.2017

Filter data for last 12 month

Hi All,

I have a set of data and where i need to filter it for last 12months can someone help on this. and also, it should act as a dynamic filter.

For Example: current month is 08.2018 then it should filter data from 08.2017 to 07.2018

below is my scenario.

Input

out put

Help

Hi Shank.

We can achieve this using some of the functions that we utilised in the solution for your post yesterday (datetimetoday() and datetimetrim()).

We also need the filter tool and the datetime parse tool.

Our filter statement would be...

datetimediff(datetimetrim(datetimetoday(),'month'),[Calender Month],'month')
<= 11

Please see the attached solution.

Ben

Hi Shank.

We can achieve this using some of the functions that we utilised in the solution for your post yesterday (datetimetoday() and datetimetrim()).

We also need the filter tool and the datetime parse tool.

Our filter statement would be...

datetimediff(datetimetrim(datetimetoday(),'month'),[Calender Month],'month')
<= 11

Please see the attached solution.

Ben

many thanks for your help this helped me a lot.

i was using differnet formula and was not able to get that.

@BenMossit should filter from 08.2017 to 07.2018 but in current case it is filtering from 08.2018 to 09.2017 how can we fix this?