6 Replies Latest reply: May 8, 2018 1:58 PM by Beck Bakytbek RSS

    Current Year vs Sum of previuos Year

    Beck Bakytbek

      Hi Folks,

       

      i have a question: my table does look like:

      Year, Turnover, Company

      2018, 500, A

      2017, 400, B

      2016, 300, C

       

      i am using this expression to show the turnover of current year:

      Sum({<Year = {"$(=Year(today()))"}>}Turnover)

       

      my question is:

      how can i show via set expression the sum of previous year (2017 + 2016 = 400 + 300)

       

      i want to show the comparison like:

      2018,   All Previous Years

      500,             700

       

      does anybody have any idea?

       

      Thanks a lot

      Beck