12 Replies Latest reply: Aug 8, 2012 8:34 AM by Deepak Vadithala RSS

    Showing results from last year

      I have the following table:     

          (The first two columns belong to CAFE and the other two to RESTAURANT)


      2011201220112012
      Earnings (No taxes)$3,000,000$3,600,000$2,900,000$3,000,000
      Earnings (With taxes)$2,300,000$3,000,000$2,500,000$2,550,000
      Spent$1,600,000$2,000,000$2,100,000$2,000,000
      Benefit$700,000$1,000,000$400,000$550,000

       

      I would like to include three new rows so I can see the benefit last year, the difference in both benefits and the % increase (or decrease).

      It would look something like this:                     

      (The first two columns belong to CAFE and the other two to RESTAURANT)


      2011201220112012
      Earnings (No taxes)$3,000,000$3,600,000$2,900,000$3,000,000
      Earnings (With taxes)$2,300,000$3,000,000$2,500,000$2,550,000
      Spent$1,600,000$2,000,000$2,100,000$2,000,000
      Benefit$700,000$1,000,000$400,000$550,000
      Last year's benefit                -$700,000                -$400,000
      Difference                -$300,000                -$150,000
      %increase                -42.86%                -37.5%

       

      The problem I have is that if I can't get to show the benefit from an earlier year in the column from a different year. This example illustrates the problem I'm having.

                                                                                               (The first two columns belong to CAFE and the other two to RESTAURANT)


      2011201220112012
      sum(<year={'2012'}> Earnings)                -$3,600,000           -$3,000,000

       

      I haven't found a solution yet. If you can think of something please let me know.