By Joyce Zhou - Updated June 23, 2015
In dynamic forms, row/column axis definition can be based on filter selection. In these cases, formatting by row, column, or cell will not work properly.
For example, in the form below, accounts on the row axis will dynamically change based on the Employee filter selection.
Row 11 has been formatted to percentage with two decimal places. It looks correct when Lilia Bryon is selected.
However, when we change Employee to Tia Albarran, the member on row has changed to Effective Hourly Rate. And the percentage format doesn’t make sense anymore.
To make this correct, we are introducing the Scope Format feature, which allows users to define format by dimension scope.
Here’s how we are going to do it.
Step 1. Right click on the scope cell. Here we are going to define the format on Effective Hourly Rate metric member, therefore we right click on B11 (or any place on Row 11). Select Define Cell Attributes.
Step 2. In the pop-up window, name this definition, and select dimension scope. In this example, we select Metric Hierarchy-Effective Hourly Rate.
Step 3. Click FORMAT tab. Enable formatting on bottom right. Then format as needed. The central white region will show real time format. Once done, click Finish.
Now you’ll see Row 11 is formatted correctly.