Difference between revisions of "Removing Zeros from a Grid Report"
(→Example: Updated for screenshot) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
(3 intermediate revisions by one other user not shown) | |||
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 5: | Line 5: | ||
==Example== | ==Example== | ||
''We'd like to remove any zero-valued members (in this case, the {{Code|Additional Equipment}} and {{Code|Other}} members) from the report.'' | ''We'd like to remove any zero-valued members (in this case, the {{Code|Additional Equipment}} and {{Code|Other}} members) from the report.'' | ||
+ | <ol> | ||
+ | <li value="1"> Right-click on the member that you want to filter against. In this example, we want to filter against the {{Code|All Periods}} member, because we want to remove any members that are zero for all time:</li> | ||
− | + | [[File:Remove Zeros 1.png|center|300px]] | |
− | + | ||
− | + | <li value="2"> Select the {{Menu|FluenceXL|Apply|Filter|Remove Zeros}} menu option:</li> | |
+ | |||
+ | [[File:Remove Zeros 2.png|center|300px]] | ||
+ | |||
+ | |||
+ | <li value="3"> The zero-valued rows are removed from your report: </li> | ||
+ | |||
+ | [[File:Remove Zeros 3.png|center|300px]] | ||
+ | </ol> | ||
==Editing the Filter== | ==Editing the Filter== | ||
# Open the [[Report Designer]] | # Open the [[Report Designer]] | ||
# Double-click the blue icon added to the axis with the filter applied: [[File:Remove Zeros 4.png|center]] | # Double-click the blue icon added to the axis with the filter applied: [[File:Remove Zeros 4.png|center]] | ||
− | # The filter is shown on the Axis Designer. You can now edit the filter in the same way as a [[Ranking, Sorting and Filtering|normal filter]], by clicking on the menu button and selecting {{Code|Edit...}}: [[File:Remove Zeros 5.png|center]] | + | # The filter is shown on the Axis Designer. You can now edit the filter in the same way as a [[Ranking, Sorting and Filtering|normal filter]], by clicking on the menu button and selecting {{Code|Edit...}}: [[File:Remove Zeros 5.png|center|400px]] |
==See Also== | ==See Also== |
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...: