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

    Calculating difference (variance) every other column


      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)