4 Replies Latest reply on Mar 24, 2015 1:13 AM by phuviet.pham

    How to calculate the Difference from previous Year

    phuviet.pham

      Hi everyone,

       

      I have the Sheet like the attachment

      Now i want to calculate the Sale difference between 2 continous years for the same productline, product, tye, market, Areacode, state.

      for Example:

       

      difference between

      year      product line   Product type  Product     Type          Market        Area code    State                   Sale

      2012       Beans           Coffee          Amaretto    Regular     Central      970               Colorado           894

      2013        Beans           Coffee         Amaretto     Regular     Central      970               Colorado           1150

       

       

      and another question: how to sort the Sale bars within Market ascending? i tried but it does not work.

       

      an you please help me how to do that?. Thanks