% variance calculation for year over year from single DP

Hi,

Is there any way that I bring the results from 2 or more years in a single data provider and have the reports show % variances?
In other words I have a DP which brings data for last 3 years. In this report if I want to compare 2010 Vs 2009 results how can I do it?
If I try to create a flag variable using max and min of year the variable becomes a Measure and it unusable in where clause. Is there any way to achieve this without having 2 different DP?
Thanks


SAP_BO_Addict :canada: (BOB member since 2003-09-18)