How to Conditionally Hide a Column?
Hello,
We are using Financial Reporting Studio 11.1.2.4.710.
We have a report that prompts the user to enter a month (Period). In column A, the report shows the Actual scenario for January to the month entered. In column B, the report shows the Budget scenario for month entered offset by 1, to December. For example, if the user enters October, the report shows Actuals for January to October, and Budget for November to December.
The issue is, if the user enters December, the report shows Actuals for January to December, and Budget for January to December, because the offset by 1 for December rolls around to January. What I would like to do is if the user enters December, do not show column B, or something that will have similar effect. What can I do to get this report to work correctly when December is entered?