Scenario 2

After reviewing the data form designed by John in Scenario 1, Acme decides that they want Budget on the column instead of the row. To implement this requirement, John can move members within the axes to change the data form layout. However, he does not need to update the data validation rules. John updates the data form as shown in the following figure.

Data Form Layout at Design Time:

Data Form Layout at Design Time

Data Form at Data Entry Time with Data Validations Applied:

Data validation example

For additional scenarios, see Data Validation Rule Scenarios.