I have the following table:
(The first two columns belong to CAFE and the other two to RESTAURANT)
| 2011 | 2012 | 2011 | 2012 |
|---|
| 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)
| 2011 | 2012 | 2011 | 2012 |
|---|
| 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)
| 2011 | 2012 | 2011 | 2012 |
|---|
| 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.
.png "Luminary Alumni"){kind=icon}
