Prompt Query

[Raghuvir]

Hi All,

i have a requirement where, when the user selects the prompt for fiscal year, for example the user selects 2014, data in the output should be 2014,2013,2012 & 2011. i.e i need previous 3 years data including the year selected.

how will i achieve this ?

Regards

[Raghuvir]

Hi All,

i have a requirement where, when the user selects the prompt for fiscal year, for example the user selects 2014, data in the output should be 2014,2013,2012 & 2011. i.e i need previous 3 years data including the year selected.

how will i achieve this ?

Regards

Hi All,

used the below condition to achieve this.

[FY_CD]>=?FY?-3 and not([FY_CD]>?FY?)

Regards