1 Reply Latest reply on Jul 19, 2017 10:28 AM by Patrick A Van Der Hyde

    LOOKUP Formatting Question

    Brian Cachuela

      Please see tab Difference in attached workbook.  My issue is explained in the caption, however, to explain here....

       

      I'm basically trying to take a Category or Subcategory count for this month.  Then, I'd like to show it next to last month and this month last year.  Then, I'd like to show the difference between this month and last month and the difference between this month and this month last year.  I've got the values, but the way I'm doing it looks ugly.  It's just doing a difference to the left value.  So I also see the differences of Last Month vs This month last year.  As well there are columns for the differences for this month, which is pointless.  Again, it is more obvious in the workbook.

       

      Any ideas?

       

      Thanks in advance.

      Brian