How to Find the previous Fiscal Period?

[sg]

Hi,

I have a FISCAL PERIOD PROMPT in my report with the values 2008 FP1,2008 FP2 upto 2009 FP9 . Now i need to remove the prompt and when i run the report it should show by default the previous fiscal period as 2009 FP9.

I have a dimension called "INVOICE.DATE" and hierarchy "INVOICEDATE.FISCALPERIOD"

Any help in this regard would be highly appreciated. Let me know if any more information is required.

Thanks,
Sg

[cschnu]

Use the Maximum Aggregate function and then minus 1

If you want to have it only be the default selection to run the report I think you will have to look into javascript, because i don't believe you can make a default selections from an expression.

[sg]

Thank you very much for the reply. I will try doing the same.



Thanks,
Sg