Selection of previous Year's month data after Selection of Current Year

[#1]

Good Morning All,

I have one Pivot table chart in which Jan09.......Dec09 and Jan10......June10 means from Jan09 to June10's Monthly Columns are available.

Now When I select Year=2009 then Jan09 to Dec09 data value appears but Jan10 to June10 's data appears as ZERO.

Similarly when I select Year=2010 then Jan10 to June10 's data value appears but Jan09 to Dec09 's data appears as ZERO.

And when I select both YEAR 2009 and 2010 then All data value starting from Jan09 to June10 appears.

Please tell me whether it is possible that I select Year=2010 and want Jan10.....June10 data with May09 data also.

Actully because of business reason Client wants May09 column data also in addition to Jan10......June10 data after selection of only Year=2010.

Please help me.

Thanks and Regards

Ajay

[#2]

Good Morning All,

I found the Solution.

I have separately crated one field in the script with Month09 data and used this field in the column of May09.

There is no relation between Year and this column value.

Thanks and Regards

Ajay