I want to create a Straight Table chart that shows something like the following:
Period Period Sales 2009/10 YTD Sales 2009/10 Period Sales 2008/09 YTD Sales 2008/09 Period % Increase YTD % Increase
01 Jul £2705.55 £2,705.55 £606.00 £606.00 346.46% 346.46%
02 Aug £746.65 £3,452.20 £699.00 £1,305.00 6.82% 164.54%
02 Sep £430.60 £3,882.80 £2,247.00 £3,552.00 -80.84% 9.31%
etc
etc
And then a total of the 2 year's values accumulated at the bottom.
In my data I have the following fields:
- PeriodNo
- PeriodName
- FinancialYear
- ExtendedInvoicePrice
Could someone point me in the right direction of what the best way of achieving this would be please?
Many thanks.
Andrew Longland
