Sum a backward

[Anonymous]

Problen with sum

In the first column I would like to have sum with sum date 2017-05-01and in the other column sum date 2016-05-01

ex

how big was sales, last year at a specific date

//Janne

[Anil_Babu_Samineni]

May be this?

Sum({<DateField = {'$(=AddYears(Max(DateField),-1))'}>} Sales)

[sunny_talwar]

What is your chart dimension here?

[Anonymous]

I have tried that variant but it will only be 0

//=Sum({<Date = {'$(=AddYears(Max(Date),-1))'}>} sales)

21767454,82->2016-05-01

3201530,09 ->2017-05-01