0 Replies Latest reply: Jun 24, 2010 11:13 AM by AndrewL RSS

    How do I create a financial year/period comparison table?

    AndrewL

      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