'Others' is a secondary total row that displays the sum of all 'unfocused' records for the active dimension at the top of the grid. It is accessed via Options > Show others.
| Info | ||||
|---|---|---|---|---|
| ||||
An additional row, 'Others', appears underneath the standard 'Total' first row.
| Tip |
|---|
The data that displays in the 'Others' row depends on which measures are selected. E.g., if Value or Profit are chosen, 'Others' will display a total, but if Margin is chosen, 'Others' will display an average. |
Removing 'Others' from view
To turn off, untick Show others. 'Others' cannot be turned off using Reset, but logging off and back on will remove the row.
Examples of use
Using 'Others' to limit the information shown in a chartThe Show Others option is available when a dimension is selected, however, it is only useful when you have selected and focused on some rows in that dimension. It displays the total of the unfocused rows below the total of the focused rows.
When this option is turned on (checkbox is selected), a new row displays at the top of the grid (below the TOTAL row) to show the sum total of all the 'unfocused' rows in each column. As you can see in the first image below, zeros will display in this row if you have not focused on some rows. When you focus on some rows, the total of the other (unfocused) rows displays.
| Info |
|---|
The data that displays in the OTHERS row depends on which measures are selected. For example, if the Value or Profit measures are selected, the OTHERS row displays a total, but if the Margin measure is selected, it will display an average. |
To remove the OTHERS row, clear the Show Others checkbox. You cannot remove this row by clicking the Reset button, however, logging off and back on will remove it.
Example 1 - Use Show Others to view a total based on information not showing on in the grid
Suppose you have filtered the grid to display data for the UK only. The total revenue for all regions in the UK is $23,305,649.11.
You then select and focus on the top 5 performing regions in the UK. The total revenue for those regions only is $6,351,192.34.
Now you want to compare the total of the top 5 performing regions with the total of all the other, unfocused regions. Click Options > Show Others. The total revenue of the unfocused regions ($16,954,456.77) displays below the total revenue of the focused regions ($6,351,192.34). The sum of these two equals to the total revenue for all regions in the UK ($23,305,649.11).
Example 2 - Use Show Others to limit the information displayed in a chart
Sometimes there is too much data to turn into a meaningful chart. In the
Sales Reps are grouped together in the 'Others' wedge.
Using 'Others' to view a total based on information not showing on your screen
In the example below, 5 regions in the UK have been focused on. 'Total' is a sum of these regions. 'Others' is a sum of all the unfocused regions. You can see that in the smaller image on the right, the total local value (circled in red) is the same as the sum of the 'total' and 'others' rows in the main image at left.