User Manual

08.13.2024

MANUAL

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="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.