Pivot table widget

The pivot table widget is one of the core functions in data analysis tools. It supports multi-dimensional grouping and flexible summarization to quickly generate structured statistical reports. Whether it's sales data statistics, inventory analysis, or operational indicator monitoring, data aggregation calculations (such as summation, average, maximum value, minimum value, etc.) can be achieved through simple configuration and displayed in an intuitive cross-tabular form.

Core Functions

1. Multi-dimensional grouping: Support grouping data by row dimension (Row) and column dimension (Column)
2. Diverse statistics: Provide multiple aggregation methods such as sum (Sum), average (Average), maximum value (Max), and minimum value (Min).

Usage steps

1. Create a dashboard

Enter the space and create a new dashboard. Click "+ Add widget" in the toolbar and select "Pivot table".

1. Configure data source

• In the widget configuration interface, specify the database (Database) and data view (View) that need to be analyzed.

1. Set row and column dimensions

• Row Dimension: Usually, a first-level classification field (such as "sales platform") is placed. Data will be grouped vertically according to this field.
• Column Dimension: Usually, a second-level classification field (such as "SKU") is placed. Data will be grouped horizontally according to this field.

Example: If you need to view the sales situation of each "SKU" by "sales platform", then:

• Row Dimension: sales platform
• Column Dimension: SKU

1. Add summary indicators

In "Summary by", configure the numerical fields and statistical methods that need to be calculated:

• Click "+ Add" and select the target numerical field (such as "sales volume").
• Set the statistical method:
  • Sum: summation
  • Average: average
  • Max: maximum
  • Min: minimum

Example: If you need to count the total sales volume of each SKU under each platform, then add the indicator: Quantity Sold → Sum

1. Generate and save

After completing the configuration, click "Save" and the system will automatically generate a pivot table. The report will display data in a cross form. For example:

• Each row represents a sales platform, each column represents an SKU, and the corresponding summary value (such as total sales volume) is displayed in the cell.

Application scenario example

Sales data statistics

Suppose the original data contains:

• Row dimension: sales platforms (Temu, Amazon, TikTok)
• Column dimension: SKU (Product A, Product B, Product C)
• Summary indicator: quantity sold (summed)

After configuration is completed, the pivot table will present the following structure:

Advanced skills

• Multiple indicator overlay: Add the same field repeatedly in "Summary by" and select different statistical methods (such as calculating "total sales volume" and "average sales volume" simultaneously).
• Dimension adjustment: If more detailed analysis is needed, multi-level row/column dimensions can be added (for example, "sales platform" + "region").
• Sorting and filtering: Click on the table header to sort the data, or focus on key information through the filter on the right.

Recommend AI Automation Templates

Discourse Community Manager

Discourse Community Manager Agent is an AI community assistant that helps you quickly generate clear, friendly, and well-structured replies to user posts. This AI reply generator makes community moderation easier, faster, and more professional.

AI Automated Task Management

Helps teams efficiently manage weekly tasks. Through a series of automation tools, including task summaries, progress reminders, and personal summary reports, team members can promptly obtain task information and progress, thereby improving collaboration efficiency and work transparency. By using these automation features, teams can maintain efficient operations and ensure that each member has a clear understanding and sense of responsibility for their tasks.

Business Contract Management

Streamline your entire contract lifecycle with the Business Contract Management template. This centralized contract management system serves as an all-in-one contract database and centralized contract repository for tracking contract details, approvals, and activities. Automate key processes through a contract approval workflow and contract workflow management, ensuring accuracy, transparency, and collaboration across teams. Ideal for project contract management, this template simplifies service request tracking, reduces manual work, and improves efficiency from contract submission to expiration reminders.

Batch generation of HeyGen AI videos

Quickly generate high-quality HeyGen AI videos with batch generation and automated video workflow. Customize characters and voices, streamline video creation, and save time.

Base CRM

Base Template in Every New Space

AI Writer

Tell me about the AI product or brand — I’ll draft engaging marketing copy, articles, and social media posts tailored to your brand voice and product details, complete with relevant links and illustrations.