cancel
Showing results for 
Search instead for 
Did you mean: 

Show last 6 month data using fiscal period

Former Member
0 Kudos
302

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

Accepted Solutions (0)

Answers (1)

Answers (1)

joseph_reddy88
Participant
0 Kudos

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
0 Kudos

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