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.
Add the widget to your monday.com dashboard in 5 steps:
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.
The following column types can be used as grouping dimensions:
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.
Each dimension chip has a sort toggle. Click it to cycle between Ascending, Descending, and Unsorted (original board order). Sorting applies independently per dimension.
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.
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.
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.
{Revenue} / {Deals}
+
-
*
/
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.
Each metric can be formatted independently:
Toggle a metric's visibility to hide it from the table without deleting it. Hidden metrics remain available as references inside formulas.
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.
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.
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.
Choose from 6 built-in themes in the Appearance tab:
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.
Enable Freeze Row Headers or Freeze Column Headers independently to keep axis labels visible while scrolling through large pivot tables.
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.
Click the Export button in the pivot table toolbar to download a styled Excel workbook. Three formats are available:
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.
Hierarchical rows with native Excel outline groups. Click + and − directly in Excel to expand and collapse dimension levels.
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.
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.
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.
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.
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.
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.
{Revenue} / {Count}
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.
Need help configuring the pivot table or have a feature request? We'd love to hear from you.
Email: [email protected]
