Difference between revisions of "Removing Zeros from a Grid Report"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| Line 1: | Line 1: | ||
| − | To remove zeros values from a Grid Report, use the {{Menu| | + | To remove zeros values from a Grid Report, use the {{Menu|FluenceXL|Apply|Filter|Remove Zeros}} right-click menu option. |
This function adds an axis-wide [[Ranking, Sorting and Filtering|filter]] to the Grid. | This function adds an axis-wide [[Ranking, Sorting and Filtering|filter]] to the Grid. | ||
| Line 10: | Line 10: | ||
[[File:Remove Zeros 1.png|center|300px]] | [[File:Remove Zeros 1.png|center|300px]] | ||
| − | <li value="2"> Select the {{Menu| | + | <li value="2"> Select the {{Menu|FluenceXL|Apply|Filter|Remove Zeros}} menu option:</li> |
[[File:Remove Zeros 2.png|center|300px]] | [[File:Remove Zeros 2.png|center|300px]] | ||
Latest revision as of 09:38, 4 July 2023
To remove zeros values from a Grid Report, use the FluenceXL > Apply > Filter > Remove Zeros right-click menu option.
This function adds an axis-wide filter to the Grid.
Example
We'd like to remove any zero-valued members (in this case, the Additional Equipment and Other members) from the report.
- Right-click on the member that you want to filter against. In this example, we want to filter against the All Periods member, because we want to remove any members that are zero for all time:
- Select the FluenceXL > Apply > Filter > Remove Zeros menu option:
- The zero-valued rows are removed from your report:
Editing the Filter
- Open the Report Designer
- Double-click the blue icon added to the axis with the filter applied:
- The filter is shown on the Axis Designer. You can now edit the filter in the same way as a normal filter, by clicking on the menu button and selecting Edit...:
