# Ability to filter/group on connected parent fields **URL:** \ **Category:** Feature Requests\ **Created:** [September 20, 2023, 4:30pm UTC](https://forums.knack.com/t/ability-to-filter-group-on-connected-parent-fields/14889 "2023-09-20T16:30:15Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![RobinB](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@RobinB](https://forums.knack.com/u/RobinB)\ **Post date:** [September 20, 2023, 4:30pm UTC](https://forums.knack.com/t/ability-to-filter-group-on-connected-parent-fields/14889/1 "2023-09-20T16:30:15Z")
I need to be able to filter grids/reports and group reports on connected fields, as well as connected-connected fields (grandparent data). While grids can display the connected fields I need, I wish to pre-filter the recordset of a connected table using a parent field. Because I currently cannot do this, I have a lot of text formula fields in my child table. Simple example: Parent record is a new home build: address, floor plan, subdivision, salesperson, buyer. Child record is modifications to each home: room, description, cost of modification. Reports/view of modifications need to be grouped/filtered (and costs summed) by subdivision, floor plan, # of modifications per buyer, etc. For instance, a list of all the requested kitchen modifications for a certain floor plan. ---
**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\ **Post date:** [September 26, 2023, 6:27pm UTC](https://forums.knack.com/t/ability-to-filter-group-on-connected-parent-fields/14889/2 "2023-09-26T18:27:52Z")
Hi, Robin! Thanks for sharing this feature request! Having this ability implemented would definitely help a great majority of our users. This idea has been shared with the Product team, and we will share any updates here as they come! Have a great week!