3 Replies Latest reply on Jun 28, 2018 11:44 AM by Mavis Liu

    Difference between previous month and current month values

    Sumedha Nagpal

      Hello, I have a table that looks like this:
      I have an aggregate amount and I am creating each row based on a dimension called  "group".
      I created a calculated field to get amounts for the current month and previous month.

       

      Is there a way to get a third column which has a percentage difference of current month from the previous month? I would ideally also like to understand how to put a green down arrow or a red up arrow.

       

      Attached workbook.

       

       

      Screen Shot 2018-06-28 at 11.08.24 AM.png