Trailing Twelve months data on line chart

[arvindjha2050]

Hello Team,

I would like to trailing twelve month's data,below is sample data for same

Script :

Load * Inline

[

TransactionDate , Sales

01/25/2017 , 15

04/25/2017 , 10

07/25/2017 , 12

10/25/2017 , 11

12/25/2017 , 10

01/25/2018 , 09

03/31/2018 , 33

04/01/2018 , 28

04/25/2018 , 25

];

I tried the below formula but how to get it for all time periods on a line chart

Sum({$<TransactionDate = {"<=$(=QuarterEnd(QuarterEnd(Today(),-1)))>$(=AddYears(Today(),-1))"}>}Sales)

For example in March,2018 it will show sum of sales from 1st March,2017 to 28th February,2018.

For example in April,2018 it will show sum of sales from 1st April,2017 to 31st March,2018 .......

Thanks,

Arvind

[Anonymous]

Hi

Try Below one.

=Sum({<Date={">=$(=MonthStart(Max(Date),-11))<=$(=Date(Max(Date)))"}>} Sales )