Manage Table: Aggregation
## Overview
Set the "[Column](/en/manual/table-management-column)" to be displayed in the "[Aggregation](/en/manual/table-record-aggregation)" field at the top of the "[Screen Index](/en/manual/table-grid)". Using "[Class Column](/en/manual/table-management-class)" enables "Grouping" by classification for aggregation purposes.
## Limitations
1. Only "「Work Volume Column」", "[Remaining Work Volume Column](/en/manual/table-management-remaining-work-value)", and "[Numeric Value Column](/en/manual/table-management-num)" can be used for "Total" and "Average" aggregation.
1. Only "[Status Column](/en/manual/table-management-status)", "[Manager Column](/en/manual/table-management-manager)", "[Owner Column](/en/manual/table-management-owner)", "[Class Column](/en/manual/table-management-class)", and 「Check Column」" can be used for "[Column](/en/manual/table-management-column)" in "Grouping".
1. "Grouping" by "[Class Column](/en/manual/table-management-class)" that have "[Multiple Selection](/en/manual/table-management-multiple-selections)" enabled cannot be performed.
## Prerequisites
1. "Site Administration Permission" is required to configure settings.
## Operation Image
![image](https://pleasanter.org/binaries/6ea779b3da054dcb9de9aabfa2bb30bc)
With the relevant table open, click "Manage" > "[Manage Table](/en/manual/table-management)" from the navigation menu.
---
![image](https://pleasanter.org/binaries/ebde9a76fa8e48f2a6f0c67029ba37eb)
"[Aggregation](/en/manual/table-record-aggregation)" is performed by "Grouping" using the "Added [Column](/en/manual/table-management-column)" to "Count", "Total", and "Average". Selecting "No Classification" performs "[Aggregation](/en/manual/table-record-aggregation)" without "Grouping".
![image](https://pleasanter.org/binaries/a5ea80ee93564d0095afec4a312411c6)
### 【Default State】
![image](https://pleasanter.org/binaries/389e86bfc72f4c9091000c130ae4ede2)
### 【Enable Owner and Aggregate the Count by Owner】
![image](https://pleasanter.org/binaries/07289b7b3fd74fff8150e3f3688e19e0)
### 【Aggregation Results on the Screen Index】
![image](https://pleasanter.org/binaries/8fc5f16e9dff4d30af72e24f83c1b199)
### 【Check Column】
If "Grouping" by "「Check Column」", "[Aggregation](/en/manual/table-record-aggregation)" is performed for "Unchecked" and "Checked" column. (Left side represents "Unchecked," and right side represents "Checked.")
![image](https://pleasanter.org/binaries/2f524981a98347d5b988b5f4a06f38d8)
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-grid">Table Function: Record Screen Index</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-record-aggregation">Table Function: Record Aggregation</a><span>10.07.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management">Manage Table</a><span>10.02.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-column">Manage Table: Column</a><span>10.07.2024 up</span></li>
<li><a href="/en/manual/table-management-remaining-work-value">Manage Table: Column: Remaining Work Volume</a><span>10.11.2024 up</span></li>
<li><a href="/en/manual/table-management-status">Manage Table: Column: Status</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-manager">Manage Table: Column: Manager</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-owner">Manage Table: Column: Owner</a><span>10.11.2024 up</span></li>
<li><a href="/en/manual/table-management-class">Table Management: Item: Classification</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-num">Manage Table: Column: Numerical Value</a><span>10.02.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-multiple-selections">Manage Table: Editor: Column Advanced Settings: Multiple Selection</a><span>10.02.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />