Multi-Dimensional Pivot Table
Plugio Pivot Table transforms your monday.com board data into interactive, multi-dimensional pivot tables. Drag any column to rows or columns, define custom metrics and formulas, color cells by value, and drill down into the items behind any number — all without leaving your dashboard.
Getting Started
Add the widget to your monday.com dashboard in 5 steps:
- 1 Open any monday.com dashboard and click Add Widget.
- 2 Search for "Plugio Pivot Table" and add it to your dashboard.
- 3 Click Configure on the widget to open the editor.
- 4 In the Pivot tab, select a board and drag columns into the Rows and Columns zones.
- 5 Switch to the Measures tab to add metrics, then click Save.
Rows & Columns
The Pivot tab contains the dimension builder. Drag any board column into the Rows or Columns drop zone to group your data along that axis. You can add multiple dimensions to each axis to build nested hierarchies.
Supported Column Types
The following column types can be used as grouping dimensions:
- Status, Dropdown — groups by label value
- Date — groups by a selectable granularity (see below)
- Checkbox — groups into checked / unchecked
- Text, Long Text — groups by exact text value
- People, Multiple Person — groups by team member
- Group — groups by the item's board group
- Item Name — lists individual items as leaf rows
Date Granularity
When you add a Date column as a dimension, the widget automatically offers granularity options: Year, Quarter, Month, Week, and Day. Select the granularity from the dimension chip in the builder. This lets you group, for example, all items created in the same month without any manual formula work.
Sorting
Each dimension chip has a sort toggle. Click it to cycle between Ascending, Descending, and Unsorted (original board order). Sorting applies independently per dimension.
Expand & Collapse
In the pivot table view, click + or − next to any group header to expand or collapse that node. Expansion state is preserved while the configuration stays the same. Leaf rows are always visible regardless of whether parent nodes are collapsed.
Metrics & Formulas
The Measures tab manages what is calculated in each cell of the pivot table. Add one or more metrics, or build custom formulas that reference them.
Metric Operations
| Operation | What it returns | Supported column types |
|---|---|---|
| Count | Number of matching items | Any (no column needed) |
| Sum | Total of a numeric column | Numbers, Rating |
| Average | Mean value of a numeric column | Numbers, Rating |
| Min | Smallest value in the column | Numbers, Rating |
| Max | Largest value in the column | Numbers, Rating |
Formulas
Create a formula metric to compute a derived value from other metrics. Reference any existing metric
by its label in curly braces: {Revenue} / {Deals}. Supported operators are
+, -, *, /, and parentheses for grouping.
The widget detects circular dependencies automatically and displays a #CIRC! error in affected cells. Formulas that reference deleted metrics are flagged with a warning icon.
Number Formatting
Each metric can be formatted independently:
- Compact — abbreviates large numbers (14.3K, 2.1M)
- Full — shows the complete number (14,312)
- Decimal precision — set between 0 and 8 decimal places
Hiding Metrics
Toggle a metric's visibility to hide it from the table without deleting it. Hidden metrics remain available as references inside formulas.
Cell Coloring
Each metric can have an independent coloring rule applied to its cells, making it easy to spot patterns and outliers at a glance. Coloring is configured in the metric's edit modal.
Gradient
Pick a base color. The widget computes a luminance-based gradient from the minimum to the maximum value visible in the table. The text color adjusts automatically for contrast.
Color Ranges
Define explicit value ranges, each with its own color. Cells that fall within a range get that color; cells outside all defined ranges are left uncolored.
Coloring is applied only to data cells — header and total cells are not colored.
Appearance
Themes
Choose from 6 built-in themes in the Appearance tab:
- Monday (Adaptive) — follows your monday.com dashboard theme automatically
- Slate, Cobalt, Dark, Violet, Forest — fixed color palettes
Totals
Row totals, column totals, and the grand total can each be toggled independently. Totals aggregate across the opposite axis — row totals sum across all column groups for each row, and vice versa.
Freeze Headers
Enable Freeze Row Headers or Freeze Column Headers independently to keep axis labels visible while scrolling through large pivot tables.
Dashboard Filter Integration
The widget automatically respects monday.com's native dashboard filters. When a viewer applies a filter at the dashboard level, the pivot table recalculates using only the matching items.
Excel Export
Click the Export button in the pivot table toolbar to download a styled Excel workbook. Three formats are available:
Normalized
One row per row-leaf × column-leaf combination. Each metric gets its own column. Flat structure — ideal for importing into BI tools or further analysis in Excel.
Drilldown
Hierarchical rows with native Excel outline groups. Click + and − directly in Excel to expand and collapse dimension levels.
Report
Merged header cells for the column hierarchy, merged row cells for grouped rows, bold totals, and formatted borders. Ready to paste into a presentation or share as-is.
All formats respect the current show/hide totals settings. Bold styling is applied to total rows and columns in all formats.
FAQ
Does my data leave monday.com?
No. The widget operates entirely within the monday.com platform using the monday.com Apps SDK. All data fetching and processing happens inside your monday.com instance. We never store, collect, or transmit your board data.
Which column types can be used as dimensions?
Status, Dropdown, Date, Checkbox, Text, Long Text, People, Multiple Person, Group, and Item Name can all be used as row or column dimensions. Numeric columns (Numbers, Rating) are used for metrics, not dimensions.
Can I use data from multiple boards?
Each widget instance connects to one board at a time. On multi-board dashboards, a board selector appears at the top of the configuration panel.
What does clicking a cell do?
Clicking any data cell opens a drill-down modal showing the exact monday.com items that contribute to that cell's value. Items are filtered by the row path and column path of the clicked cell.
How do formulas work?
Formulas reference other metrics by label: {Revenue} / {Count}. They support
+, -, *, /, and parentheses. Circular
references are detected and shown as #CIRC!. A metric referenced in a formula
can be hidden from the table without breaking the formula.
Why are some cells empty?
A cell is empty (shown as —) when no items match the intersection of that row group and column group. This is expected behavior for sparse data.
Support
Need help configuring the pivot table or have a feature request? We'd love to hear from you.
Email: [email protected]