how can we write expression for current year sales(chart should change dynmicaaly for next year?

[#1]

Hi

how can we write expression for current year sales(chart should change dynamically for next year?

[Anil_Babu_Samineni]

Dynamically for next year means

Sum({<Year = {'$(=Max(Year))'}>}Sales) // It will give 2017 data sales if you have till 2017 data. In future, If you are adding or updating for next year it will return 2018 data point of sales

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

[sunny_talwar · Accepted solution]

May be this

Sum({<Year = {"$(=Year(Today()))"}>} Sales)

[#4]

Sum({<Year = {'$(=Max(Year))'}>}Sales)   ////  it shows the 2018 year.I didn't get 2017

if i write this expression sum({$<Year={$(=max(Year)-1)}>}Sales) //// i get 2017 year,what is the reason. plz tell me

Gopichand

[Anil_Babu_Samineni]

May be you have forecast data for 2018 too.