Summing Series Values by Category

Problem

When there are multiple series in a chart, it is desired to display show the sum of the values of each series in the category name, as shown in the following figure.

Implementation Method

You can set the form of the chart category name to solve the problem.

Report Design

1. Create a dataset named ds1. The database query statement is SELECT * FROM Sales_Volume.

2. Merge required cells, and insert Stacked Bar Chart, as shown in the following figure.

3. Set the Display of the chart, select Formula Form, and enter the formula $$$+":"+sum(value("ds1",5,4,$$$)).

Note:

$$$ refers to current values, and the following formula means to extract the data of the fifth column corresponding to the current value (namely Product) from ds1 and sum it up.

4. Set the chart label, as shown in the following figure.

Effect Display

PC

Save the report and click Pagination Preview. The following figure shows the preview effect.

Mobile Terminal

For details, you can click to download template Summing Series Values by Category.cpt.