Show last 6 month data using fiscal period

[Former Member]

Hi Experts,

I have fiscal period and Year in report and have to restrict webi to show last 6 month data.

I hvae to schedule this report weekly.

My issue is:

How to restrict the report to show last 6 month record using fiscal period and year.

Fiscal Period format is "MMM YYYY"

Thanks,

Ankit

[joseph_reddy88]

Hi Ankit,

What is the source of your report,If it is BEX we can do this automatically using the variable exits ,based on current date we can automatically get last 6 months fiscal period data.

Else convert current date to fiscal year period i.e Current fiscal period using if condition based on the fiscal year variant, then derive from fiscal year (current - 6) variable and do the restriction in formula.

="FY-"+ FormatNumber(If(MonthNumberOfYear([Uvdate])>=7;   Year([Uvdate])+1;   Year([Uvdate][Uvdate]));"####")

Try to understand the fiscal year and cal month relationship before you apply above formula.

Regards,

Joseph

[Former Member]

Hi Joseph,

I understand that in fiscal year we need to take care of fiscal year variant but I do not have such case.

We are going to schedule the report for 2 year and want to see last 6 month data in one of the tab.

Is there any way i can achieve this using fiscal period.

Thanks,

Ankit