Search Results

Calculating the sum of two or more columns

The total sum of all values in two or more data columns can be calculated.

In the following example, the data contains Q1 and Q2 sales figures for cities in different countries. Assume you want to display the total sales for each country across the two quarters, for example, in a cross table. This means the sum of the values in the Sales Q1 and Sales Q2 columns should be totaled.
Example data

First, a cross table is created as shown below.
Cross table

Procedure

  1. Right-click the cell values axis to open the pop-up menu.
  2. Select Custom Expression.
  3. In the Custom Expression dialog, enter the expression Sum([Sales Q1])+Sum([Sales Q2]).
    The expression calculates, per country, the sum of the values in the two columns.
  4. Click OK.
    The cross table shows the total sum of Q1 and Q2 for each country.
    Cross table with totaled columns