--- title: "Set Up Totals in the Aggregator Panel to Summarize Data in Pigment" slug: "totals-aggregator-panel" description: "Use Pigment’s Aggregator Panel to add totals and subtotals, customize Views, and save configurations for clear, reusable data analysis." tags: ["Aggregators", "applications", "blocks", "Data Visualization", "Reporting Data Visualization ", "Security and Permissions "] updated: 2026-03-31T08:44:24Z published: 2026-03-31T08:44:24Z --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.pigment.com/llms.txt > Use this file to discover all available pages before exploring further. # Set up Totals in the Aggregator Panel You can choose to visualize your data using aggregators in any Block (List, Metric or Table), and save it as a View. ## Before you begin > [!WARNING] > ⚠️ Important > > You need the `Configure Public Views` [permission](/v1/docs/roles-permissions-access-rights#permissions) to save Views containing aggregators. ### Choose the right time Dimension Take care to choose the right time Dimension when using sum aggregators. As sum aggregators add up the Dimension Item specified, a sum applied to a time Dimension of Quarter would give you a total for the year, not the Quarter. To obtain subtotals by Quarter, add Quarter as a time Dimension then add a sum aggregator for Month, as follows: 1. Select the Metric with monthly data from the left sidebar. 2. Select **Pivot** from the top toolbar. 3. Select **+** by **Columns**. 4. Find **Quarter**from the options provided and select **Add**. Close out the panel. 5. Add a sum aggregator to Month using [the step-through below](/v1/docs/totals-aggregator-panel#add-an-aggregator-to-a-metric). ## Add totals and other aggregators You can add totals and other calculations to a row or column in your View by using aggregators. The following are available, depending on the Block’s [data type](/v1/docs/data-types-in-pigment): | **Aggregator** | **Data Type** | | --- | --- | | `Any`: returns TRUE if at least one of the elements is true. | Boolean | | `All`: returns TRUE if all the values are true and FALSE if all the values are false. Note that blank state Booleans are ignored. | Boolean | | `Sum`: calculates the sum of a Dimension | Number, Integer | | `Avg`: calculates the average of a Dimension | Number, Integer | | `Min`: calculates the minimum value of a Dimension | Number, Integer, Date | | `Max`: calculates the maximum value of a Dimension | Number, Integer, Date | | `Count`: counts the number of values of a Dimension | Number, Integer, Dimension, Date, Text | | `Count All` : counts the number of Items within a Dimension | Number, Integer, Dimension, Date, Text | | `Count Distinct`: counts the number of different Items within a Dimension | Number, Integer, Dimension, Date, Text | | `Count Blank`: counts the number of blank Items within a Dimension | Number, Integer, Dimension, Date, Text | | `Concatenate`: joins the contents of cells together | Text | | `First`: shows the first cell of a Dimension | Number, Integer, Dimension, Date, Text | | `First Non Blank`: shows the first value of a Dimension | Number, Integer, Dimension, Date, Text | | `Last`: shows the last cell of a Dimension | Number, Integer, Dimension, Date, Text | | `Last Non Blank`: shows the last value of a Dimension | Number, Dimension, Date, Text | | `Blank`: imposes blanks, preventing aggregation. Useful after expanding or collapsing rows and columns which automatically introduces ANY or SUM by default. | Number, Integer, Dimension, Date, Text, Boolean | | `Advanced aggregator`: allows aggregations such as ratios and growth measures. For more information, see [Advanced aggregators](/v1/docs/totals-aggregator-panel#advanced-aggregators) below. | Number, Integer | ### Add an aggregator to a Metric 1. Open a Metric you’d like to aggregate. 2. Select the **Σ** symbol from the top toolbar to open the Aggregator Panel, pictured below: ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image-1773135799971.png) 3. All the Dimensions in your Metric are listed. Select **+ Add** by the Dimension you would like to aggregate. 4. From the drop-down, select the aggregator you want to add to your View. 5. (*Optional*) Add aggregators to more than one Dimension. 6. (*Optional*) Toggle on **Show every subtotal**. See the [**Show every subtotal** section](/v1/docs/totals-aggregator-panel#show-every-subtotal) for information on this option. 7. Save your View, so that you can go back to it even after you've made changes to your Block. > [!NOTE] > ℹ️ Note > > If an Item is [filtered](/v1/docs/filter-data-pigment) out, it is not included in the total. For example if I am looking at Revenue, and I add a filter that excludes France, the total revenue does not include France. ### Add an aggregator to a Dimension 1. Open a Dimension List you’d like to aggregate. 2. Select the **Σ** symbol from the top toolbar to open the Aggregator Panel, pictured below: ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image-1773135869664.png) 3. All the Properties in your Dimension are listed. Select **+ Add** by the Property you would like to aggregate. 4. From the drop-down, select the aggregator you want to add to your View. 5. (*Optional*) Add aggregators to more than one Property. > [!NOTE] > ℹ️ Note > > By default, aggregators are shown on the last line. In large Lists, you may want to see totals at the top to avoid scrolling. For more information on how to display aggregators on the top line, see [Customize the layout of your Views](/v1/docs/customize-layout-views#totals). ### Add an aggregator to a Table 1. Open a Table you’d like to aggregate. 2. Select the **Σ** symbol from the top toolbar to open the Aggregator Panel, pictured below: ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(283).png) 1. All the Metrics appearing in your Table are listed. Open and close Metrics in the list using the arrow to add aggregators to them. 2. Select **+ Add** by the Dimensions found under **DIMENSIONS IN GRID**. They appear to the right of your data. > [!NOTE] > ℹ️ **Note** > > In addition to the aggregators [listed above](/v1/docs/totals-aggregator-panel#add-totals-and-other-aggregators), Tables can make use of advanced aggregators. For more information, see the [Advanced aggregators section](/v1/docs/totals-aggregator-panel#advanced-aggregators) below. 3. (*Optional*) Add aggregators to the Dimensions found under **OTHER DIMENSIONS**. See which Dimensions are hidden by hovering your pointer over the Item. 4. (*Optional*) Where a Dimension appears in multiple Metrics appearing in your Table, you can choose to have the same aggregator apply everywhere they appear. Select the button to the right of **Add**labelled **Apply to all Metrics based on this Dimension**. 5. (*Optional*) Toggle on **Show every subtotal**. See the next section for information on this option. > [!NOTE] > ℹ️ Note > > Aggregations on Calendar Dimensions are performed before aggregations on other Dimensions. ## Show every subtotal To display subtotals for Dimension, turn on the **Show every subtotal** toggle at the bottom of the View Aggregators panel. In the following example, the Metric is composed of two Dimensions: Country and Product. The Metric on the left has subtotals turned on, which allows you to see the totals for each product, along with the total for all products and countries. The Metric on the right shows the total for countries and products because the **Show every subtotal** toggle switch is turned off. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/2ce46261-cba3-4bef-9eb3-97e2c35e2b4d.png) ## Advanced aggregators Tables can make use of advanced aggregators that show ratios, growth and other calculations between Metrics. Use the [step-through provided above](/v1/docs/totals-aggregator-panel#add-an-aggregator-to-a-table) until Step 3, then do as follows: 1. Open Metrics in the list using the arrow to add the advanced aggregators. 2. To add an advanced aggregator to a visible Dimension, select **+ Add** by the Dimension under **DIMENSIONS IN GRID**. To add an advanced aggregator to a hidden Dimension, select the drop-down under **OTHER DIMENSIONS** that shows **Sum** by default. 3. Scroll to the bottom of the drop-down and select **Advanced aggregator**. 4. In the pane that opens, select one of the **Calculation**options. 5. Under **Metric A** and **Metric B**, select the two Metrics to perform the calculation. Note the following: - By default, the advanced aggregation is performed on the sums of Metric A and Metric B. For example, if you chose a **ratio** advanced aggregator, the Pigment engine sums Metric A and Metric B, then calculates the ratio on those sums. You can change this to be a ratio of minimums, maximums or one of the other aggregation types, by editing the aggregators on the Metrics you chose for Metric A and Metric B. If you need, you can select **Pivot** and **Add this Metric again**, and choose a different aggregation on it, then pick that aggregation for your advanced aggregation calculation. - Metric A or B can also be Metrics that are in the Table but hidden from view through **Pivot**. These are also hidden in the Aggregator panel, so to choose an aggregator other than sum for them, you must temporarily show them in **Pivot**. 1. Select **Apply**. The advanced aggregator is created, along with aggregations against the Metrics you chose for Metric A and Metric B. > [!NOTE] > ℹ️ Notes > > - [Show Value As](/v1/docs/show-values-as) operations are not supported. > - Advanced aggregators are not for use in Metrics’ and Lists’ Views, only in Tables. > - For best results, the Metrics you reference should be dedicated and single-purpose.