reporting hierarchies

This may have been already answered, but is it possible to setup a report to display all the child rows of a hierarchy when a parent row is selected? I have different information on several sheets with a couple common reporting columns, but I still run into the problem of report criteria either being too narrow or too broad; if I could setup the report to display all the child rows of the selected parents (which have a common identifer across all the sheets), I could print a summary report of one project (or one type of project), including all conversations and projects/tasks in process associated with that project, which would be EXTREMELY useful.

I'm hoping there's some simple trick to this that I am missing as a newbie.

Elliot

Find more posts tagged with

Reports

Comments

Zack S

Hello Elliot,

At this time we don't have a way to include hierarchies in reporting so that if a parent row is pulled all child rows are pulled as well, but I'll add your vote for this capability to our enhancement request list for our Product team to review.

-Zack

Colleen Haupt

Please add my vote too. It makes the use of reporting not very helpful when sharing a project plan with executives. I exported to Excel where hierarchies are shown. However printing is unusual.

Travis

I have added your vote, Colleen!

Elliot Liebson

Update; I've been poking around my sheets, with the help of your tech support (plug to Luka here), and between my searching and his suggestions, I have a workaround that does pretty well.

I setup a checkbox column, and each cell in the column containts the following formula: "=IF(Priority2 = "0 New Lead", 1, 0)". 'Priority 2' is one of the categories in a separate dropdown column, depending on the the prospect's level of interest (this is basically a sales pipeline tracking system). On the report side, I have the report built on 'priority is 'X'', and 'Report check is checked', to get only the rows with updates for each priority level on a single report. I still have to update each prospect manually, but I set up a separate standing report for each priority level, which automatically updates when I save the changes (sorry if this is a little basic).

I also created duplicate columns from my other sheets (meeting follow-ups and sales pipeline by stage), and put them in one master sheet. Since I can create specific reports for each set of parameters I want, there's no reason not to have everything on one data sheet, as I've filtered out or hidden all the extraneous data on each report.

Again; apologies if some of this is a bit basic; it took me a long while to get here, and I wanted to walk through the process so that someone else doesn't have to slog through it like I did.

JohnHinkle

Great input, thanks Elliot!

Dawn Morgan

Please add my vote too. We have users here at the bank who want to roll reports up to provide to the Exec Team and want to display both the "parent" & "child" rows/data in a collapsable format. Currently it displays but just shows in cells that kind of seem out there by themselves.

Travis

Hi Dawn - I submitted your vote for this!

Alisa Collins

Add my vote as well. Thx.

CDE

Add mine as well. I'm working on a report across 6 teams, with over 2000 rows, over 70 collaborators and now I have to go in and paste data (repeating) into every column someone wants to filter on or it won't show up.

Travis

Alisa and CDE - your votes have been added!

Tim Meeks

Please add mine. If reporting is just a filter of the sheet, then it should be able to keep the heiarchy more simply than me adding a formula in all of my sheets.

I'm in the same boat as CDE> Not as many users, but when it is more complex solution, I am not able to develop users who can master the solution themselves.

Great job security but hard to sell to senior management.

Tim

Travis

Added, Tim!

Alicia K

Has any progress been made on retaining hierarchy of parent and collapsable child rows in reports? I also have the need to share reports with exec and I want to be able to hide the minutia from their simple, high-level view. In the meantime, how can I create a report showing only the parent rows? (And ... thanks for your input guys!;)

Kate French

Hi Alicia,

Though this isn't on our Product Roadmap currently, we are tracking input from our customers on this, and I've added your vote for it to our enhancement request list!

Dawn Gagnon

my vote as well please. I have about 15 sheets in 15 different workspaces I need to roll up into one report