# Feature OP-20004 - Two-dimensional (pivot / cross-tab) reporting over work-package attributes

Project: OpenProject
Status: new
URL: https://community.openproject.org/work_packages/OP-20004

## Planning

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Target versions | Wish List |
| Sprint |  |
| Backlog bucket |  |
| Votes | 1 |
| List |  |
| Roadmap |  |
| Relevance |  |

## OPEN POINTS / FEEDBACK

_No work packages_

## Features and Chunks

_No work packages_

## Bugs and other work packages

_No work packages_

## Technical Details

| Attribute | Value |
| --- | --- |
| Module | Modules and project features / Query and filter, Modules and project features / Work packages, Frontend components and Primer design system |
| Feature Flag |  |
| Requires doc change | No |
| Enterprise plan |  |

## Details

| Attribute | Value |
| --- | --- |
| Pull preview |  |
| Mockups |  |
| Accessibility | No |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Feature Lead |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |
| Work |  |
| Labor costs |  |

## Description

**As a** member of a review team analysing work packages,
**I want** to cross-tabulate work packages by two attributes at once — one on the rows and one on the columns — inside OpenProject,
**so that** I can see the distribution across two dimensions repeatably, without exporting to Excel and rebuilding a pivot table by hand each time.

**Acceptance criteria**

* I can configure a two-dimensional report in which rows are grouped by one work-package attribute and columns by a second work-package attribute.
* Both the row and column dimension can be any groupable work-package attribute (status, type, priority, assignee, author, project, version, category, dates, custom fields, …).
* Each cell shows the **count of work packages** for that row/column combination; row totals and column totals are shown.
* Optionally, the cell measure can be the **sum of a numeric attribute** (e.g. estimated time, spent time, a numeric custom field) instead of a plain count.
* The cross-tab is scoped by a filter/query, so I can restrict which work packages are counted.
* The configuration is a **persistent, repeatable, shareable** report inside OpenProject — not a manual export that has to be recreated each time.
* Optional: clicking a cell drills down to the underlying filtered list of work packages.

**Technical notes**

* OpenProject already has a genuine pivot/cross-tab in the **cost report** module (rows and columns each set to a group-by criterion). The reason it does not answer this need is its **measure**: it aggregates time and cost only, and excludes work packages without time/cost entries. This request keeps the same two-dimensional grouping idea but with **work-package count** (or an arbitrary numeric aggregate) as the value.
* The work-package table already supports **one-dimensional** grouping (group by one attribute, with group sums). Conceptually this feature adds the **column dimension** and a count measure on top of that existing grouping.
* Likely shares data-model and UI patterns with both the cost report's grouping engine and the existing table group-by — worth checking whether one of those can be generalised rather than built fresh.

**Out of scope**

* Charts / graphical visualisations of the pivot (the ask is the tabular cross-tab; charts could be a later follow-up).
* Extending the **cost report** module itself to work-package measures — this is about work-package reporting and need not be bolted onto the cost module.
* Preserving the pivot structure in Excel/PDF exports (the current cost report already drops group-by settings on export; matching or fixing that is a separate concern).
    

_Set the_ **To be informed/consulted teams** _field to include all teams necessary to be informed of the changes._
