I am building a report in which i want to show the output in columns as
Quantity (this year) / Quantity (previous year)
So i restrcited quantity with fiscal year / period and put a variable of interval.
What problem i am facing is that my POWER USER WANTS TO VIEW IT AS
Quantity (Jan- ... 2007) / Quantity (Jan- ... 2006)
This Jan - ... 200 selection should be user entry ..
So if i run the query and user has to select Jan- March of 2005
then this range should also represent on the Report output.
I hope you got what i mean to say.
So whatever range they enter it should visible on the report
The requirement is not to show month by month but aggregate quantity of range entered as well as the
VISIBILITY OF RANGE ENTERED.
i created and restricted for previous year and also set the offset year, It is solved
The problem is how shall i display the range of months they enter in Report output