We have requirement like when the user enters the Fiscal Year 2015 as prompt value and Accounting Period May month as a prompt Value then the report should display only 13 months of data that is from May-2014 to May-2015 in the report, we have 24 months columns as measures in the report
When the user enter the Fiscal Year-2015 as prompt value and Accounting period May month as a prompt value then the report should display only 12 months of data that is from May-2014 to May-2015 and other columns measures should be hidden.
Accounting Period as a prompt from Jan to Dec that is from 01-12
Can any one provide the solution for this requirement.
Thanks & Regards
Have you got date object in report or universe?
If yes then you can easily do it on report level by implementing following logic:
1) Create a variable :
Data_show = if [date] >= relativedate([date];-12) then "show" else "hide"
2) Now using these variable you can create report level/block level filter lik
Data_show = "Show"
3) After applying same it will show you only required columns.