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

Automated Currency Data Retrieval (Python)

The Automated Currency Data Retrieval (Python) template runs a scheduled job to fetch specific currency rates every day and store them in a structured table, building clean historical exchange rate data over time. Use it for financial data automation that powers dashboards, alerts, and automated financial reporting, so finance teams, forex traders, accountants, and risk managers always have up-to-date FX data at hand. By automating data collection, you save time, reduce manual errors, and make better investment and risk decisions based on reliable exchange rate history.

Automated Stock Data Retrieval (JavaScript)

The Automated Stock Data Retrieval (JavaScript) template automatically fetches US stock data every day and writes it into a structured table, giving you clean, consistent time series for analysis. Use it as part of your financial data automation stack to power stock trend analysis, dashboards, alerts, and quantitative analysis data for models and backtests. Designed for financial analysts, investment managers, data scientists, quants, and portfolio managers, it saves time on manual data collection so you can focus on research, strategy, and better investment decisions.

Dynamic Email Automation for Partner Onboarding

Streamline your partner onboarding with dynamic email automation that sends personalized messages, tracks engagement, and triggers timely follow-ups. Improve partner engagement, automate notifications, and optimize your onboarding workflow while reducing manual tasks. Perfect for startups, referral partners, and tech collaborations, this solution ensures seamless communication automation for stronger partnerships.

Automated Currency Data Retrieval (JavaScript)

The Automated Currency Data Retrieval (JavaScript) template runs daily jobs to fetch exchange rates and write them into a table, giving you clean, structured historical exchange rate data without manual copy‑paste. Use it for financial data automation that feeds dashboards, alerts, and automated financial reporting, so finance teams, forex traders, accountants, and analysts always have up‑to‑date FX data. Over time, the template becomes a lightweight risk management tool by helping you monitor currency movements, spot trends, and support better investment and hedging decisions.

AI Invoice Information Recognition

This AI Invoice Information Recognition template uses invoice OCR AI to automatically extract key fields from invoice images and turn manual entry into financial data automation. Set up an end-to-end invoice processing workflow that captures invoice numbers, dates, amounts, and taxes, and stores everything in a structured database. Extend the same flow to receipt data extraction and purchase order processing so finance teams, SMEs, and accountants can handle bulk documents faster, reduce errors, and keep all financial data accurate and searchable.

Contractor / Freelancer Management

Streamlined contractor and freelancer management template that centralizes resources, automates application reviews, approval workflows, task assignment, and tracks project expenses for full transparency and budget control.