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