Skip to main content

Edit a Table

Use the Edit Table window in the PowerPoint and the OfficeReports App or the Table Pane in Excel to change the settings for an existing table.

Table Content definition

  1. In the OfficeReports App, double-click a cell in the table.
  2. In Excel, click a cell in the table.

OfficeReports opens the Edit Table window or the Table Pane, where you can change all table settings.

Filter​

Use the Filter tab to define a table filter. The categories you select are included in the data used for the table.

For example, if you select Finance, HR, and Marketing, OfficeReports excludes the categories that are not selected.

If you need a filter based on multiple variables, first create a derived variable. The derived variable must contain a category with the data you want to use in the filter.

For information about filtering entire reports, see Report Filter.

You can use any combination of categories from a categorical variable as a filter, including categories from a derived variable.

If a table contains a category that is filtered out, the category name is still shown, but the number of observations or responses is 0. To hide a filtered-out category from the table, select Do not show in the Options box.

!['Do not show in table' definition](/Resources/Images/OfficeReports Analytics/Filter_1_3.png)

Ignoring Filters​

Use Ignoring Filters to exclude selected filters when OfficeReports calculates the table. This is useful for report automation, for example when batch generating reports.

Add a Filter Declaration​

To add the filter declaration to the table title, select Add to title in the Filter tab.

You can also use the Filter tab to ignore the Report Filter or any of the Segment Filters.

For example, when you create reports for each department, you may want one table to show results for the whole company. In that case, you can ignore the department filter, whether it is defined as the report filter or as a segment filter.

Statistics​

Use the Statistics tab to define Z-test and T-test settings for tables.

Read more about Significance Testing.

Table Statistics definition

Weighting​

To use weighted data, specify a Weight Variable. This can be:

  • a numeric variable you imported
  • a numeric weight variable calculated by OfficeReports

For information about calculated weights, see Weighting Data.

If you need to weight all or most tables, set a default weight variable in OfficeReports > General Settings.

Sorting​

OfficeReports can sort rows and columns in ascending order, descending order, or in the same order as another table. You can also use any Excel Named Range for this.

Video: Sort in Same Order as.

Table Sorting definition

If you use a Reporting Table Layout in Reporting Mode, you can also sort Mean or Total together with the categories.

Layout​

Use the Layout tab to control the table layout.

Table Layout definition

By default, OfficeReports uses the layout defined in Layout Settings. You can override this for an individual table by selecting a different layout in the Layout list.

Title for Frequency Tables​

For tables that contain one variable, OfficeReports uses the variable text as the default title.

To use a different title, enter it in the Title field.

Title for Cross Tables​

For tables that contain two variables, OfficeReports provides several title options.

The title can be:

  • Variable text
  • Optional variable text
  • Variable text x Optional variable text
  • Optional variable text x Variable text
  • User defined title

![User defined title for table](/Resources/Images/OfficeReports Analytics/Title cross.png)

The default title setting is defined in the Layout section.

Hide the Explanation of the Cell Summary Variable​

For tables that contain summary statistics in the cells, OfficeReports adds this information to the title by default.

Clear this option if you do not want to show that explanation.

Ranking​

Use Ranking to show the rank of each category compared to the other categories in the table.

This feature works for frequency tables, cross tables, and grid tables. It works with percentages, observations, and numeric values in cells.

You can display the ranking by row or by column, and sort it in ascending or descending order.

![Table ranking definition](/Resources/Images/OfficeReports Analytics/Rank.png)

You can also choose to show the ranking only for categories with a minimum base of observations.

For example, you can use ranking to show which department performs best on different dimensions. The ranking can be based on mean values or on statistics such as Top 2.

![Ranked crosstab](/Resources/Images/OfficeReports Analytics/Rank_1.png)

By default, the table shows ranking as 1 of 5. If you prefer 1 out of 5, change this in Table Settings. You can also choose to show only the rank number.

Ranking in Table Settings

Hide​

Use Hide to hide selected categories without changing the calculation results.

Unlike Filter, Hide does not affect the underlying calculations.

Hide in Table definition

not in range COMPSET​

Use not in range COMPSET to hide brands that are not part of a defined competitor set.

To use this feature:

  1. Select a range in Excel.
  2. Right-click the range.
  3. Select Name.
  4. Name the range COMPSET.
  5. Make sure the range contains all brands needed for the specific country report.
  6. Select not in range COMPSET.

OfficeReports then hides all brands that are not listed in the COMPSET range.

See also​