Table function: Cross-tabulation display of records
## Overview
Displays the records stored in the "[Table](/en/manual/table)" in "[Crosstab](/en/manual/table-management-crosstab)" format.
## Prerequisites
* Read permissions are required.
## Operation Procedure
1. Open the table list screen.
1. Open the "Display" menu and click "[Crosstab](/en/manual/table-management-crosstab)".
## Display Switching Items
By adding classification items, you can increase the number of vertical and horizontal aggregation items. For column classification, you can select a classification item or a date item. For row classification, you can select a classification item or a numerical item. The aggregation can be toggled between count, total, average, maximum, and minimum. Date display can be month, week, or day.
![image](https://pleasanter.org/binaries/1c6415e79b1945798add6ec959660d7a)
## Cross-tabulation Settings
You can change the cross-tabulation settings. This operation requires site administrator permissions.
1. Open the target table.
1. Click "「Table Management」" from the "Management" menu.
1. Open the "「Cross-tabulation」" tab.
1. Set up according to the table below.
|Item name|Description|Setting method|
|:---|:---|:---|
|Enable|Enable/Disable cross-tabulation|Check to enable cross-tabulation|
1. Click the "Update" button at the bottom of the screen.
## Conditions For Selectable Items In Column Classification
1. "[Classification Item](/en/manual/table-management-class)" or "[Date Item](/en/manual/table-management-date)" with options
1. Items for which "[Multiple Selection](/en/manual/table-management-multiple-selections)" is not specified
1. Items that are enabled on the edit screen
1. Items that have not been unreadable in "[Item Access Control](/en/manual/table-management-column-access-control)"
## Conditions For Selectable Items In Row Classification
1. "[Classification Item](/en/manual/table-management-class)" or "「Numerical Item」" with options
1. Items other than multiple selection
1. Items that are enabled on the edit screen
1. Items that have not been unreadable in "[Item Access Control](/en/manual/table-management-column-access-control)"
## Settings For Not Displaying Rows With 0
If you want to display only rows with values, check the "Do not display rows with 0" checkbox.
![image](https://pleasanter.org/binaries/703fbea97e904dc9a57eaad8a01816e0)
You can filter by row, but not by column.
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table">Table Function</a><span>08.13.2024 up</span></li></ul></article>
<ul><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-date">Table Management: Item: Date</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-multiple-selections">Table Management: Editor: Item Detail Settings: Multiple Selection</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-crosstab">Managing Tables: Crosstab</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-column-access-control">Table Management: Access Control: Item Access Control</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />