YTD Calculation

[#1]

Hi,

I have a Pivot table where I need to do YTD calculation.I have a dimension 'month' in yyyymmdd format and an expression "sum(ANR)". I need to show data as per current year YTD(ie. Jan-Apr 2009) and same prev year YTD(Jan-Apr 2008). The report will look like:

Jan09 Feb 09 Mar09 Apr 09 09YTD-Total Jan08 Feb 08 Mar08 Apr08 08YTD-Total

ANR 100 200 300 100 700 100 100 100 100 400

Please help ASAP.

[deepakk]

can we make this report in this type. This format will be much easier for reading and understanding.

year	month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
2001		0	0	54,630.23	0	0	0	8,217.05	13,903.26	208,697.63	249,608.67	150,771.91	48,052.01	733,478.27
2002		363,631.12	246,402.03	128,223.73	402,773.34	199,011.73	300,756.28	86,775.67	0	0	217,163.62	96,459.75	64,043.46	2,057,153.03
2003		26,427.82	141,386.14	14,581.74	53,779.32	285,859.05	0	56,284.82	50,689.00	165,426.92	102,560.14	143,744.16	56,848.63	1,063,266.05
2004		103,203.46	118,049.10	94,150.90	55,365.38	0	0	0	0	0	0	0	0	370,768.84
Total		493,262.40	505,837.27	291,586.60	511,918.04	484,870.78	266,032.10	151,277.54	47,151.81	343,477.30	569,332.43	390,975.82	168,944.10	4,224,666.20