Monday Pivot tables to mimic Excel pivot table

We would like to be able to build pivot tables to summarize the information of a table that contains thousands of rows.
Example: a pivot table that would show the number of Id per person (person column and Unique ID column). With a “count” we expect to have 2 columns as a result: a name column, and a “Number of ID” column, not thousands of boxes with “1” when there is a match between a name and an ID.

In the example described, it imitates a group function that is automatic when we set the “count” parameter to a value.

Blockquote Taking the example below, the current behavior is as follows:
the Pivot table will always create a column for the parameter you choose. For example, if you use the “ID” column, a new column for each one of the unique IDs on the board will be created, and the total will be displayed at the very end or button, as I showed in the video. Now if the numbers were the same for some items, for example this case where I have similar numbers in the numbers column, the Pivot table will show it accordingly.

Hi Leihanne (@Leihanne),

I’m Arun from Decadis AG, and I’d like to recommend our app, sumUp for Monday, as a solution tailored to your use case. We believe it’s the perfect fit for your needs.

With sumUp for monday, you can effortlessly pivot large datasets in either one or two dimensions using our powerful widgets. For example, here’s a demonstration of pivoting a large monday board with 700 items:

pivoting larger data sets


(Right-click on the GIF/image and select “Open Image in New Tab” to view it in full screen.)

Try the app yourself and experience the capabilities of sumUp for monday firsthand. If you have any feedback or would like to discuss your use case in detail, please don’t hesitate to reach out—I’d be happy to assist.

Best regards,
Arun