Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

'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. 

Image Removed

Info
iconfalse
titleRelated topics

An additional row, 'Others', appears underneath the standard 'Total' first row.

Image Removed 

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 chart 

The 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.

Image Added
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.

Image Added

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.

Image Added

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).

Image Added

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

screen shot

image below, rather than attempt to chart all

sales reps

Sales Reps, just 6

reps

Sales Reps have been selected and focused on, and

'

the Show Others

'

option has been

switched

turned on. The percentages in the

resulting pie chart remain

resulting pie chart remain accurate, and there is no clutter. All unfocused

reps

Sales Reps are grouped together in the 'Others' wedge. 

Image Modified

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. 

Image Removed 

Tip

The data that displays in the 'Others' row depends on which measures are selected. For example, if Value or Profit are chosen, 'Others' will display a total, but if Margin is chosen, 'Others' will display an average.

 

 

 

 

 

On this page

Table of Contents
minLevel1
maxLevel2

Related pages

Panel
bgColor#E3FCEF

Video

More options for displaying data