1 Reply Latest reply on Aug 21, 2017 5:42 PM by Shinichiro Murakami

    Compare vs last year (displaying information for this year only)

    Cecilia Saldaña

      Hello,

       

      Is there a way to display 2017 information compared vs 2016, without showing 2016 columns? (It might sound confusing, so please take a look at the example below).

       

      Sales 2016Dif vs prev yearSales 2017Dif vs prev year
      10122
      86-2
      1515

      0

       

      I want to see this:

      Sales 2017
      Dif vs prev year
      122
      6-2
      150

       

      If I use filter I will not be able to obtain the dif vs previous year (because I would not have access to 2016 data in the table when displaying only 2017)

      If I use Hide column I will need to alter my dashboard each year or month, depending on what I need to display...

       

      Any suggestions for this case?

       

      Thank you,