3 Replies Latest reply on Aug 3, 2017 7:32 PM by Zhouyi Zhang

    Showing previous available period on top of current period

    David Recuero Guerra

      Hi everyone,

       

      Please refer to the attached workbook. I am trying to show in the same graph the current value of the allowances, and the previous available value as a reference line in the chart for comparison purposes. I created a table calculation called ''allowances previous quarter'' LOOKUP(SUM([Total allowance]),-1) and dragged it into the view, but it shows null values.

       

      Let me know if you have any ideas.

       

      Thank you very much.

       

      David