Including Parents in Report
I'm creating a report and filtering by the value in a particular column. However, I would like to see the parent rows as well. In the original sheet, I can create a filter and check the box that says "include parent rows". However, in the report, I don't have that option when selecting a filter. How can including the parent rows be accomplished in the report?
Answers
-
Hi @BSADK
Reports evaluate a sheet on a row-by-row basis, without registering the Hierarchy. This means that the parent rows in your source sheet would need to match your Filter criteria in order to display in the Report.
It's likely we could create a "helper" column with a formula to auto-populate data in your parent rows in the sheet, so that you can then use this in your Report filter. Here's another Community post with an example: Parent/grand-parent rows in reports
If you need help with this, please post screen captures of your sheet and report, but block out sensitive data.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives