I have this type of information in a table. put into a pivot table.
Is there a way of using pivot table formulas to work out LFL perofrmance
formula would be ((this year-Last Year)/Last Year)
Anyway of doing this please??
<tbody>
</tbody><colgroup><col><col span="2"><col><col></colgroup>
Is there a way of using pivot table formulas to work out LFL perofrmance
formula would be ((this year-Last Year)/Last Year)
Anyway of doing this please??
Year | Wk No | YrWk | Sales Manager | Sales $$ |
2011 | 1 | 201101 | Steve | 2,476.05 |
2011 | 2 | 201102 | Matt | 665.29 |
2011 | 3 | 201103 | Sue | 7,374.54 |
2012 | 1 | 201201 | Steve | 4,483.00 |
2012 | 2 | 201202 | Matt | 732.49 |
2012 | 3 | 201203 | Sue | 6,186.23 |
<tbody>
</tbody><colgroup><col><col span="2"><col><col></colgroup>