Pivot Table

Create two-dimensional pivot tables

Aggregate data by rows/columns and display it as a pivot table.

Specifications

Field Roles

Pivot tables aggregate rows and columns as dimensions, and values as metrics, then display the results in a table format.

Item	Role	Notes
Rows	Dimension	One or more
Columns	Dimension	Optional
Values	Metric	Supports numeric/string metrics

Tips

Drill Down

Pivot tables can display rows hierarchically and allow collapsing them.

How to Configure

1. Set multiple row fields

   • In chart settings "Rows", set two or more fields such as major category and minor category.

   • Example: Prefecture (major category) → City/Town/Village (minor category)

2. Switch to tree display

   • "Advanced" > "Layout" > "Default hierarchy type" > Select "Tree".

     • Grid: Traditional table format

     • Tree: Display in hierarchical structure, expandable/collapsible with expand/collapse icons

3. Set initial state to collapsed (optional)

   • Check "Start collapsed" to show all hierarchies collapsed in the initial display.

Notes

• This setting is only available when there are two or more row fields

• Report viewers can freely expand and collapse

Processing Differences

When using pivot tables, the results may differ depending on the data processing method. Pivot tables use in-memory processing and query processing.

• In-memory processing

  • No row or column limits, so all data can be displayed

• Query processing

  • Limited to 30 rows and 30 columns

    • If it exceeds 30, rows or columns are grouped into Others