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|XLCubed|Apply|Filter|Remove Zeros}} right-click menu option.
+
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>
  
# 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: [[File:Remove Zeros 1.png|center]]
+
[[File:Remove Zeros 1.png|center|300px]]
# Select the {{Menu|XLCubed|Apply|Filter|Remove Zeros}} menu option: [[File:Remove Zeros 2.png|center|400px]]
+
 
# The zero-valued rows are removed from your report: [[File:Remove Zeros 3.png|center]]
+
<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.

  1. 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:
  2. Remove Zeros 1.png
  3. Select the FluenceXL > Apply > Filter > Remove Zeros menu option:
  4. Remove Zeros 2.png


  5. The zero-valued rows are removed from your report:
  6. Remove Zeros 3.png

Editing the Filter

  1. Open the Report Designer
  2. Double-click the blue icon added to the axis with the filter applied:
    Remove Zeros 4.png
  3. 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...:
    Remove Zeros 5.png

See Also