3 Replies Latest reply on Apr 21, 2018 9:39 PM by Eva K

    % YTD difference from previous ytd or year-to-month

    Eva K

      i have a dataset for the entire year 2016, 2017 and ytd 2018. I am plotting a bar chart for sum(amount) by Year, the user wants the % YTD difference from the previous YTD  or year-to-month in the hover over.



      I added a table calc which computes the Percent Difference from previous year, but it's not computing the previous ytd or year-to-month.

      I have attached the twbx file.