Pivot Table Gadget
Totals, Formatting & Export
Control summary rows/columns, number and date formatting, drill-through behavior, and how to export your pivot data.
Summary Rows and Columns
| Setting | Effect |
|---|---|
| Show Totals Row | Adds a sum row at the bottom of the table |
| Show Totals Column | Adds a sum column on the right |
| Show Percentage Column | Shows each row value as a percentage of the grand total |
| Show Average Column | Adds an average column - choose basis: all values or non-zero values only |
Number Formatting
| Setting | What It Controls |
|---|---|
| Number Format | Separator style for large numbers (1,234 vs 1.234) |
| Decimal Places | Precision for calculated values |
Date Field Formatting
When a date field is used as a row or column field, you can control how the dates are grouped and displayed:
| Format | Example |
|---|---|
| Day | Jan 06, 2025 |
| Week | Week of Jan 06, 2025 |
| Month | January 2025 |
| Quarter | Q1 2025 |
| Year | 2025 |
Make Values Clickable (Drill-Through)
When enabled, any cell value in the table becomes a clickable link. Clicking a cell opens the matching list of Jira issues in a new browser tab.
Note: Drill-through works on table display types. It is not available for chart display types.
Export
| Format | What Is Exported |
|---|---|
| CSV | Complete pivot matrix including row/column headers, all values, and totals |
| PNG | Image snapshot of the current display (table or chart) |
| Configuration | JSON export of all settings for reuse or backup |
Tip: Export as CSV to analyze the pivot data in Excel or Google Sheets. The exported file preserves all row and column headers so you can apply your own formulas and conditional formatting.