# Group Pivot Tables by Many-to-Many Linked Fields

**URL:** <https://community.noloco.io/t/group-pivot-tables-by-many-to-many-linked-fields/1514>\
**Category:** Feature Requests\
**Tags:** feature-request\
**Created:** [December 4, 2024, 11:41pm UTC](https://community.noloco.io/t/group-pivot-tables-by-many-to-many-linked-fields/1514 "2024-12-04T23:41:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![fundmore](https://avatars.discourse-cdn.com/v4/letter/f/54ee81/32.png) [@fundmore](https://community.noloco.io/u/fundmore)\
**Post date:** [December 4, 2024, 11:41pm UTC](https://community.noloco.io/t/group-pivot-tables-by-many-to-many-linked-fields/1514/1 "2024-12-04T23:41:44Z")

</div>

I noticed that pivot tables cannot be grouped by a linked field if the linked field allows linking to multiple records.

You can see that the “Originators” option has an arrow, but no additional options appear under it:

 ![pivot_tables](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/7/730816947994f28dd3e9bc74543b01a4e559fdc9.jpeg)

My use case is to show a leaderboard of sales reps who funded the most this month. The component is set to the Advance object, which contains a field called “amount” ie. the funded amount.

I want to show the total funded this month, grouped by rep. But I can’t group by rep, because each Advance can be associated with multiple “Originators” and therefore it’s not groupable.

(My workaround was to create a rollup field on Users to sum up their associated Advance amounts, and then to use a regular table set to the Users object. But this only works for all time - there’s no way to filter a rollup field to just this month.)