Skip to main content
Dexter + Chaney Spectrum

Original post by Geoffrey Falk

One of my favorite new features in version 14 is our new “tree grid” functionality. This type of screen allows you to group the information in a variety of ways and then lets you expand a section as needed.

Using the ‘Group by’ Feature

Each tree grid screen has standard groupings built in. Click the drop down arrow on the Grouping Selector to choose a different format. Once selected, the screen will redraw using this methodology.

Use the Grouping Selector to redisplay the information using this ‘Group by’ format.

The Grouping Bar can be used to create additional formats. To create a new one, drag the column title onto the Grouping Bar. To create a subset of the first group, drag another column title after the first one.

For example, on the G/L Detail Analysis Inquiry, drag the ‘Year’ column title onto the Grouping Bar. Then drag the ‘G/L period’. Now you have financial information sorted first by year and then by fiscal period.

TIP: Drag one column at a time to create this stacked group.

The Summary Bar displays the grand total of all numerical information displayed on the grid. Date columns will display the latest date here as well.

Click the Printing icon and you are first prompted to select which columns to include. Click OK and the report will preview to the screen.

The Excel icon will export the grid, using its group by format, to your spreadsheet program. This exports whatever information you see on the screen, so if there were columns that weren’t needed, use the Tablet icon to remove them.

The Tablet icon allows you to hide columns that aren’t needed in both the display, the export and when printing.

Saved Selections

After you have configured the screen to your liking, be sure to use Saved Selections to store this format for future use.

What Our Clients Say

"It’s a pleasure working with Robert. He's very patient, knowledgeable and goes far beyond to help with any issues we have as a company or as an individual."

HL Contractors

"Greg is terrific, and I’m so excited to have a better resource! I have him working on several projects now with many more to come."

Progressive Plumbing

"We appreciate Tim and all of his excellent support."

M.J. (Manufacturing Firm)

"Beth is absolutely wonderful to work with! I appreciate her patience and professionalism. It’s a relief to know I can count on her to respond and be a life line for us as we continue to learn the system. She is truly top notch."

Eastbound Mechanical

"He did a great job online and an equally great job in person. We’re enjoying working with our new Spectrum Viewpoint accounting software."

Chambliss & Rabil Contractors, Inc.

"The level of service CDP provides is exceptional and always far exceeded my expectations. You can quote me on that!"

The Wesson Group LLC

"I want to let you know how grateful we are for Robert Pacheco’s assistance. He was able to meet with me and discuss the issue promptly and complete the fix within a short amount of time. He is surely an asset, and we are thankful to have such a great resource."

Marques General Engineering, Inc.

"I wanted to let you know Dan did a great job. He has a vast amount of knowledge, and I feel very fortunate to be working with him."

H.F. (Mechanical Contractor)

"Thank you for your assistance/responsiveness to assist us in getting P6 back online so quickly today. We appreciate all the support you provide."

M.J. (Manufacturing Firm)

"Michael and Matthew have exceeded my needs and expectations. I get help same day 95% of the time, which is very important in my business at times. They are professional and courteous 100% of the time. Zero complaints."

Mitchell Brothers

"Kristen is a very valuable resource for us!"

LCI-Lineberger Construction Inc.