Cross Table Hide Detail command

Hide Detail command (Layout menu)

Once you got the result in a Cross Table worksheet, you can sometimes wish to hide one or several detailed information in a sub level.

To do so, select first the level whose detail must be hidden and click on the command <Layout> <Hide Detail> or on the corresponding icon on the Cross Table toolbar.

$image\mincross.gif$

The selected level can be all the columns or all the rows or only one or several columns or one or several rows.

Example: in the following example all details are displayed for that cross table having 2 levels in rows (Family and Product names) and 2 levels in columns (area and year) and displaying the quantity sold.

$image\result1.gif$

How to hide detail for all the columns or rows?

(Here the example concern the area column)

Click on the upper left arrow on the left side of the cross table (that arrow is on the area level), all the area column header will be selected as you can see in the following example:

$image\result2.gif$

Now, click on the Hide Detail icon or on the command <Layout> <Hide detail>. The result will be the quantity for each area, without the detail for the year 1999 and 2000:

$image\result3.gif$

How to hide detail only for one or several columns or rows ?

(Here the example concern the area column)

Click on the required header column (and other header column if you want to select more than one column) with the key Ctrl and making a click at the same time on the next required column): the selected column will appear selected as you can see in the following example:

$image\result2b.gif$

Now, click on the Hide Detail icon or on the command <Layout> <Hide detail>. The result will be the quantity for each area, without the detail for the year 1999 and 2000 only for the selected columns EAST and SOUTH. The other columns are still displaying the detail:

$image\result3b.gif$

The same rule can be applied to the rows, but in that case you will click on the arrow above the Family level, on the top side of the cross table, if you want to select all the rows ADULT and CHILDREN in the above example, then click on the Hide Detail icon or on the command <Layout> <Hide detail> to get no detail for each product.

Tips : you can also make a double click on a specific level, for example ADULT or CHILDREN or NORTH to hide detail for the concerned level only.

On the previous example, the Hide Detail command has been applied to the row ADULT and to the columns EAST and SOUTH, giving that result:

$image\result4.gif$

On the previous example, the Hide Detail command has been applied to all the rows and all the columns, giving that result:

$image\result4b.gif$