In the second video on Sage 100 Business Insights Explorer, you’ll discover how to configure the secondary grid, adding fields from other tables, creating calculated fields, and customizing data views with colors and groupings. You’ll also learn how to save these settings as default views for future use and export data to Excel. The step-by-step walkthrough ensures you can efficiently analyze and present data, enhancing your reporting capabilities. Whether you’re grouping by item number, calculating extended costs, or setting up gross profit fields, this session equips you with practical tools to streamline your workflow in Sage 100.
This video is also available as a blog: Sage 100 Business Insights Explorer: Configuring the secondary grid
In this video you’ll learn how to:
Configure the secondary grid and add fields for enhanced data analysis
Create calculated fields for extended costs and gross profit directly in Sage 100
Customize views with colors, groupings, and save settings for future use
Related Videos
What’s new in Sage 100 version 2025
Sage 100 is a powerful, customizable ERP solution designed to help growing businesses gain better control over financials, inventory, operations, and reporting. With flexible deployment options and robust functionality, Sage 100 supports smarter decision-making and scalable growth.
Sage 100 add-on solutions showcase: Part 1
Discover how to extend your Sage 100 functionality with our Add-On Solutions Showcase video. Watch demos of Avalara, Sage Alerts & Workflow, and Sage AP Automation, and learn how Sage 100 integrations can streamline workflows, reduce manual tasks, and boost efficiency across your business.
Unlock Insights with Sage 100 Business Insights Explorer
Explore the powerful features of Sage 100 Business Insights Explorer. Learn how to customize data grids, filter and group information, and create tailored views for efficient reporting. Plus, see how to export data to Excel, Word, and other applications for easy sharing and analysis.