2 Replies Latest reply on Nov 14, 2017 6:08 AM by Brent Mathison

    Calculating difference (variance) every other column

    daniel.leekim

      Hi, I have been working on a crosstab and was trying to calculate a variance for three different categories over 2016 and 2017. When I use the quick table difference calculator, I do get the right number I am looking for but my numbers are all overlapping because it is trying to find the difference between every column and not just between 2016 and 2017. I have attached a screenshot for reference but is there a way to just show the calculation of 2017 minus 2016?

       

      Thank you very much for any help given!

       

      (just attached the picture in the edit sorry)