4 Replies Latest reply on Sep 16, 2018 4:16 PM by Deepak Rai

    I would like to create a calculated field that shows the value of last month that has sales data.

    Ruy Aguilar

      My data set includes all months of the year in messy format. (201801 = Jan 18, 201802 = Feb 18, all the way to 201812 = Dec 18)

       

      I only get sales values for month to date with a lag of a month. So currently I only have values up until 201807 (July 18)

       

      I would like to add a text line on my dashboard that says: Data is updated as of ..... Calculated field saying July 18 in this case changing to Aug 18 next month.

       

      Any help will be greatly appreciated.

       

      Ruy Aguilar