Working with Tables

Objective

After completing this lesson, you will be able to change data displays and add new rows/columns to a table.

Work with Tables

Watch this short demonstration to see how you can work with tables in the SAP Analytics Cloud, add-in for Microsoft Excel.

Learn how to change data displays, format tables, add rows and columns, and customize display options for better readability using the SAP Analytics Cloud, add-in for Microsoft Excel.

Measure Displays and Formatting

You can define how numeric values are displayed in your table, either for all measures or for a single measure. These formats are defined on the Number Format tab in the Designer panel.

Number Format tab of the Designer panel is highlighted.

Totals Displays

You can show totals in your table, both in rows and columns. Depending on the placement of dimensions, showing totals could result in subtotals and total sums.

To add a totals row, right-click the dimension and select Show Totals.

In the following example, you can see that you can arrange totals and parent nodes above or below the values that make up the total by using the context menu on rows or columns. You can also suppress zeros and swap the axes of the table.

Context Menu options from the Designer tab.

New Rows/Columns

You can insert new rows and columns into a table. These new elements persist after navigation steps that trigger a table rebuild, such as a refresh or swapping axes.

Select a cell in the table and choose Add Rows/Columns from the ribbon. In the new cells, you can work with Excel formulas or insert text. The entries remain when you refresh or navigate in the workbook.

Note

If the dimension member associated with an added row or column is removed from the table through a navigation change, the row or column will temporarily disappear. It will reappear if the member is added back to the table.
Add Rows/Columns options as selected from the ribbon.

Summary

You should now be able to change data displays and add new rows and columns to a table.