Skip to Content
0
Former Member
Dec 01, 2006 at 05:34 AM

To get last year Net Value

40 Views

Dear all,

Kindly guide me on this issue.I have the report where it consists of Planned Quantity and Net Quantity sales for this Fiscal year and this report is period wise for the current fiscal year.Well with this i need Net quantity sales of previous year.I have created one Restricted Key figure where have resricted for Net sales quantity and Fiscal year/period and have used value range variable from fisc year-1 and to fisc year-1.Have used Fiscal year/Period with variable "from fisc year to to fiscal year in the column section above the key structure.

Have placed fiscal year varient in filter section.

Whn i save and execute the query its asking me to specify fixed value for fiscal year varient.I cant specify as am comparing with previous fiscal year that too particular period wise.

Note this am creating on Multiprovider and all required Key figures are available for me.

Kindly help me out...Its urgent.

Chandru

Whn i execute the query