MicroStrategy ONE

Hiding and re-displaying a metric column

You can hide a metric object (usually a column) on a grid report, yet that metric's data will still be included in any subtotals and grand totals you might have displayed. You can also display any previously hidden metric column so that the metric's data now shows in your report.

Depending on whether you have MicroStrategy OLAP Services, the procedure is different to hide a metric column. To determine whether you have OLAP Services, see OLAP Services. Use the appropriate procedure below to hide or re-display a metric column.

With OLAP Services

Hiding a metric column

If you have MicroStrategy OLAP Services, you can hide any metric column by simply dragging it off the grid report into the Report Objects pane to the left of your report. (If you do not see the Report Objects pane and you have OLAP Services, from the View menu select Report Objects.)

Displaying a previously hidden metric column

You can show any hidden metric column by right-clicking the metric in the Report Objects pane and selecting Add to Grid.

Without OLAP Services

Hiding a metric column

To hide a metric column on a report

  1. Open a grid report.

    The example image below shows a report with two metric columns, Revenue and Percent Growth.

  2. From the Format menu, select Resize Columns and Rows. The Resize Columns and Rows dialog box is displayed.

  3. Under Columns, choose the Fixed option. In the drop-down list underneath, select the metric you wish to hide.

  4. Enter 0 in the Width field.

  5. Click OK.

The report automatically updates with the metric column you selected now hidden. In the example image below, the metric Revenue has been hidden, although the Percent Growth remains the same.

Displaying a previously hidden metric column

Follow the procedure above for hiding a metric column. Instead of choosing the Fixed option, select Auto Fit to Contents and click OK. The report automatically updates with the column now showing.