2 Replies Latest reply on Feb 4, 2019 3:22 AM by Norbert Maijoor

    Display Previous Year Quantity in the Tooltip

    Alexander Elfering

      What I am trying to accomplish is showing the previous year's quantity in the tooltip for each category depending on the year that is currently being filtered on.

       

      Here is what I have tried to create:

      So if the year filter is set to 2010, I would like to show 2009's quantity in the tooltip:

       

      Previous Year:

      IF [Year] = [Year] then [Year]-1 end

       

      Previous Year Quantity:

      {FIXED [Previous Year]: SUM(Quantity)}

       

      But what I am running into is the quantity calculation is still giving me the amount in the filter. I attached some sample data in this message. Any help?