User Manual

10.07.2024

MANUAL

Table Function: Cross-tabulation Display of Records

## Overview Displays the records stored in the "[Table](/en/manual/table)" in "Crosstab" format. ## Prerequisites * Read permissions are required. ## Operation Procedure 1. Open the table list screen. 1. Open the "Display" menu and click "Crosstab". ## Display Switching Columns By adding class column, you can increase the number of vertical and horizontal aggregation columns. For class column, you can select a class column or a date column. For row classification, you can select a class column or a numerical value column. 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 "[Manage Table](/en/manual/table-management)" from the "Manage" menu. 1. Open the "Crosstab" tab. 1. Set up according to the table below. |Column 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 Columns In Class Column 1. "[Class Column](/en/manual/table-management-class)" or "「Date Column」" with options 1. Columns for which "[Multiple Selection](/en/manual/table-management-multiple-selections)" is not specified 1. Columns that are enabled on the edit screen 1. Columns that have not been unreadable in "「Column Access Control」" ## Conditions For Selectable Columns In Row Classification 1. "[Class Column](/en/manual/table-management-class)" or "[Numeric Value Column](/en/manual/table-management-num)" with options 1. Columns other than multiple selections 1. Columns that are enabled on the edit screen 1. Columns that have not been unreadable in "「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">Manage Table</a><span>10.02.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-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="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.