Hi,
I got a report where in i need to do a calculation between the actual and target for the month and also comparision with same month of previous year.
Month Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08
Actual 210 210 230 230 230 230 230 230 230 230 240 250 245 250 260
Target 220 210 240 240 240 240 240 240 240 240 240 240 240 240 240
Year Compariosion 106.5% 108.7% 113.0%
Month Comparision 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 100.0% 104.2% 102.1% 104.2% 108.3%
As you can see from the above table (some dummy data), the month comparision is the division of Actual/Target for each month. Where as Year Comparision is between Actual/Target of the month of this year / actual/target of the same month of previous year.
In the above e.g. (Mar -08 Actual /Target) / (Mar 07 Actual/Target) is compared.
Please let me know how i can achieve the same in the reports.
Thanks