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.
