Step 2: The dialog box, as shown in the following image, appears.Step 1: Click on the dialog box launcher under the “outline” section of the Data tab.The steps to group data with preceding totals are listed as follows: Let us add the totals before the data of a particular country. In the previous method, the totals were added at the end of every country. The consolidated summary of every country can be seen, as shown in the following image. Clicking the plus sign (+) hides the sub-items of each country.

Clicking on “auto outline” groups the range included in the country-wise total.Click on “auto outline” in “group” under the Data tab. To each country, add subtotals manually, as shown in the following image.In an Excel sheet, enter the data as shown in the following image.No-code required.The steps to create an auto outline with succeeding subtotals are listed as follows: WorkApps Package your entire business program or project into a WorkApp in minutes.Digital asset management Manage and distribute assets, and see how they perform.Resource management Find the best project team and forecast resourcing needs.

Intelligent workflows Automate business processes across systems.

Governance & administration Configure and manage global controls and settings.

Streamlined business apps Build easy-to-navigate business apps in minutes.

Integrations Work smarter and more efficiently by sharing information across platforms.

Secure request management Streamline requests, process ticketing, and more.

Process management at scale Deliver consistent projects and processes at scale.

Content management Organize, manage, and review content production.

Workflow automation Quickly automate repetitive tasks and processes.

Team collaboration Connect everyone on one collaborative platform.

Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.

How to do quick analysis in excel 2010