4 Replies Latest reply on Mar 19, 2018 7:32 AM by laura shal

    Creating a year over year variance with multiple years of data available

    laura shal

      Good afternoon,

       

       

      I am currently working on a report
      using crosstabs with data available for the years 2016, 2017, and 2018. A
      column I have in my crosstab are the variances to compare one year to another
      (for example: 2018 v 2017). Last year, I had no problem showing the variances
      here because I could just use a quick table calculation for 2016 and 2017 and
      then hide the 2016 column. However, with 2018 data now available, I would like
      the end users to be able to filter between 2016, 2017, and 2018 and be able to
      compare any two years at a time. What I noticed was happening on my end is that
      since I have 3 years of data I can choose from, the hiding a column method does
      not work anymore.

       

      Would there be any workaround this?
      Thanks for any answers provided!