4 Replies Latest reply on Feb 25, 2016 2:21 PM by Paddy Kavanagh

    Displaying monthly difference without needing to hide the blank month

    Paddy Kavanagh

      Hi,

       

      I'm trying to display the difference from last month of KPI figures as seen in the displayed picture below.

      It should show Jan & Feb figures in the 'difference' fields but the views get messed up at the 1st of every month and shows the blank first month.

       

       

      I am using the following method:

      I need the views to display the top 2 month's of figures but it uses the last 3 months of figures within its calculations.

      As you can see, when a month moves on to the next, I need to hide the oldest month's empty cell.

       

      Does anyone know of a more automated way of displaying the figures without the need of hiding the blank celled month?

       

      Thanks,

      Paddy