Skip to Content
0
Aug 25, 2015 at 12:56 PM

Conditional Hiding of columns in Webi report

881 Views

Hi Experts

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

Ravi Shankar