| Table of Contents |
|---|
...
Introduction
Show/Hide 
is Hide is a feature used to hide certain columns or headers of the selected report. Here were are going to explain how this feature is used in different datablocks.
...
Using Show / Hide Columns
On Cube Report
In a cube report usually , the report is usually in form of chart. If we want to display it in grid mode, then comes the feature for Show/Hide columns. It gives user option to display the desired columns as well as column headers. As in the screenshot below we can see we have two
There are 2 options at the top 1. :
Select/Deselect All
...
- Select/Deselect all the columns
...
Show Column Headers
...
- Selected by default
...
. Deselect to not display column headers
...
We also have option to sort our columns. On the left hand side, all column names are displayed in alphabetical order and on . On the right side, they are ordered as they are displayed in grid. In case we wish to
To change the order of display in grid we can simply , drag the column name from left to right on the position where we you want it to be displayed. e
E.g. In the screenshot below, we wanted 'want Hour ' to be displayed at the top, so we dragged it from the left side to the right, at the top-most position and in topmost position. In this process, it pushed the 1st first position column to the 2nd second position.
...
Metric Grid
Drillthrough
On Drillthrough
Show/Hide Column lists all the column names to select/deselect, as well as a textbox to search for column name in case list is very long.
...
On Score Card
Score Card already has standard set of columns. Use Show/Hide Columns to hide any column or column header.
...
On Generic Grid
This is similar to Cube Report show/hide option.
...
On Spreadsheet
If a report is selected from Choose Datasource, then the icon for Show/Hide Columns appears and you can then select/deselect any column to display on the spreadsheet.