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.