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

Interview Questions

Streamline your hiring process with Bika.ai’s Interview Questions template. Create and manage interview forms, checklists, and tables while automating reminders and task assignments. Evaluate candidates’ management style, cultural fit, and key weaknesses efficiently. With a centralized recruitment dashboard, monitor candidate selection, track interview feedback, and optimize your recruitment strategy. Ideal for HR leaders, recruiters, and hiring teams seeking a smart, automated way to improve hiring efficiency and ensure precise talent screening.

Employee onboarding

Streamline your new employee onboarding process with this customizable template featuring onboarding automation, pre-onboarding checklists, onboarding tasks, and automated reminders. Optimize HR workflows, ensure seamless integration of new hires, and track progress efficiently from document signing to training completion, enhancing productivity and employee experience.

Assortment Planning

The Assortment Planning template is a retail assortment planning solution that helps you manage product assortment planning across categories, seasons, and channels. Use it as a centralized product catalog management system and manufacturer database to support supplier relationship management and retail product management. Track pricing, costs, and product margin analysis, organize your product portfolio planning with clear categories and color variants, and use built‑in category management tools to keep assortments optimized for every store or sales channel.

Daily Standup（Wecom）

Automate your daily standup process with this powerful Daily Standup Template. Improve work progress tracking, streamline team check-ins, and eliminate manual updates through AI-powered workflows. With built-in daily task reminders, smart scheduling, and an advanced AI report generator for daily and weekly summaries, this template helps teams achieve true workday automation and stay aligned effortlessly.

Competition Management

Manage every stage of your competition with ease using this advanced competition management template. From participant registration and automated registration reminders to blind review, preliminary review, scoring system setup, and real-time event dashboards, it streamlines the full event workflow. Organizers can track participant data, submissions, and scoring transparently, ensuring fairness while reducing manual work. Ideal for academic competitions, innovation contests, sports events, and corporate challenges.

AI Auto-Tweet with Image

Automate your X (Twitter) content with the AI Auto-Tweet with Image template. Use it as a Twitter post scheduler and Twitter automation tool that reads tweet content from your database, generates tweets with AI, uploads images, and auto-posts to X. Batch pre-write tweets, update their status to Publish, and let the workflow handle tweet scheduling, posting, and link tracking—perfect for social media managers, creators, and brands who want consistent Twitter activity without manual posting.