Applying Filters, Adding Columns, and Organizing Your Reports

Overview

zzTakeoff reports provide powerful ways to analyze, organize, and review your takeoff data. Whether you're preparing an estimate, validating quantities, or sharing information with your team, customizing your reports helps you focus on the information that matters most.

This article explains how to apply filters, add or remove columns, and organize report data to create reports that match your workflow.

Applying Filters

Filters allow you to narrow down the data displayed in a report. Instead of viewing every item in your project, you can focus on specific information such as areas, assemblies, item types, or custom criteria.

To Apply a Filter:

1. Open the desired report.
2. Locate the Filter section within the report toolbar.
3. Select the field you want to filter by.
4. Choose the desired value or criteria.
5. Apply the filter to update the report results.

Common Filter Examples

• Show only items from a specific drawing.
• Display quantities for a particular assembly.
• View only count items or linear measurements.
• Isolate specific scopes of work.

Tips

• Multiple filters can be combined to create more targeted views.
• Filters affect only the current report view and do not modify project data.
• Clearing filters returns the report to its full dataset.

Adding and Removing Columns

Columns determine which information is displayed within your report. Customizing columns allows you to focus on the most relevant data while hiding unnecessary information.

To Add Columns:

1. Open the report.
2. Select the Columns or Column Chooser option.
3. Browse the available fields.
4. Enable the columns you want displayed.
5. The report updates automatically.

To Remove Columns:

1. Open the column selection menu.
2. Uncheck the columns you no longer need.
3. The selected columns are removed from the report view.

Common Columns

Depending on the report type, available columns may include:

• Item Name
• Quantity
• Unit of Measure
• Assembly
• Drawing Name
• Area
• Description
• Cost Information
• User-Defined Fields

Tips

• Use only the columns needed for your current task to improve readability.
• Add custom fields to reports when additional project information is required.
• Different report types may provide different column options.

Organizing Report Data

Organizing report data makes large reports easier to review and analyze.

Sorting Data

Sorting allows you to arrange information in ascending or descending order.

To sort a column:

1. Click the column header.
2. Click again to reverse the sort order.

Common sorting options include:

• Alphabetical by item name
• Quantity highest to lowest
• Drawing number order
• Area or assembly grouping

Grouping Data

Grouping combines similar records together under a common category.

Examples include grouping by:

• Assembly
• Drawing
• Area
• Item Type
• Trade or Scope

Grouping can help summarize quantities and improve report navigation.

Reordering Columns

You can rearrange columns to place important information where it is easiest to view.

To reorder columns:

1. Click and hold the desired column header.
2. Drag it to a new location.
3. Release to place the column.

Many users place quantity, item name, and cost information near the beginning of the report for quicker review.

Best Practices

• Apply filters before exporting reports to reduce unnecessary data.
• Remove unused columns to keep reports clean and readable.
• Sort or group data to quickly identify discrepancies and trends.
• Create report layouts that match your estimating and review processes.
• Verify filtered results before sharing reports with customers or team members.

Summary

Report customization in zzTakeoff allows you to quickly find, organize, and present the information you need. By using filters, selecting the appropriate columns, and organizing data through sorting and grouping, you can create focused reports that improve visibility, accuracy, and efficiency throughout the estimating process.