Other Levels Excel Dashboard: A Guide to Multi-Level Views

Yes—Excel can show a dashboard at different levels of detail, from a high-level summary to team, product, or transaction views. “Other levels” is not the name of a standard Excel dashboard feature; if you mean a particular product or organization called Other Levels, the phrase alone does not identify a public dashboard. For a multi-level report, Excel 365 for Windows commonly uses PivotTables, PivotCharts, filters, and separate summary and detail sheets.

What “other levels” can mean in Excel

A dashboard usually presents selected measures in a compact, visual form. A “level” can mean the scope of the information, such as company, region, and store, or the amount of detail, such as monthly totals versus individual orders. Excel does not impose one definition. The report designer chooses the hierarchy and how readers move between its levels.

For example, a sales dashboard might open with total revenue and order count. A regional manager could filter it to one region, then inspect results by store or product category. A separate detail sheet could show the underlying orders. This is a reporting design, not a separate Excel dashboard mode, and it can be built in one workbook.

There is also an Excel feature called worksheet outlining, which groups rows or columns and lets users expand or collapse them. It can be useful for structured reports, but it is not the same thing as an interactive dashboard. Likewise, a PivotTable’s expand-and-collapse controls show more or less detail within a hierarchy; they do not automatically create a polished dashboard.

Common ways to organize dashboard levels

Choose levels that match the questions your readers need to answer. A useful hierarchy is usually familiar to the business and consistent in the source data. Common patterns include:

Organization: company, division, region, and location.
Time: year, quarter, month, and day.
Products: product group, category, and individual item.
Operations: overall process, department, work queue, and individual record.
Audience: an executive summary, a manager’s operational view, and a detail report for analysts.

These are examples, not a requirement to create several dashboards. Often one summary page with a small number of filters and a clearly labeled detail page is easier to maintain than a separate dashboard for every group. The right structure depends on who will use the workbook and what decisions the report supports.

Prepare the source data before building

Multi-level reports are only as dependable as their source. Put the source records in a consistent, rectangular table: one header row, one record per row, and one field per column. Avoid merged cells, blank header names, subtotal rows inside the data, and inconsistent spellings such as “North” and “N.” for the same region. Those issues can produce confusing filters or split what should be a single category.

In Excel, select the source data and use Insert > Table. Give columns clear names such as Date, Region, Store, Product, and Sales. A structured Excel Table expands when new rows are added, which makes it a convenient PivotTable source. Check that dates are real Excel dates rather than text, and that values intended for arithmetic are numeric. If the data comes from an external system, confirm how often it is refreshed and whether the workbook contains all required records.

For levels based on time or category, decide how values should be grouped before publishing. A date field can be grouped in a PivotTable, while a reliable year or month column in the source can make the grouping more explicit. If categories have a parent-child relationship, keep both fields in the data—for example, Category and Product—rather than relying on a manually arranged display that could become out of date.

Build a summary and detail view

In Microsoft 365 for Windows, a straightforward starting point is a PivotTable. Select a cell in the source table, choose Insert > PivotTable, and choose where the PivotTable should go. Place measures such as Sales in Values, and fields such as Region or Month in Rows or Columns. Add filters only when they help answer a real reporting question.

To create a chart, select the PivotTable and choose Insert > PivotChart. Use a chart suited to the comparison: a line chart can show a trend over time, while bars can compare regions or categories. Keep the summary page focused on a few important measures. A second sheet can hold a more detailed PivotTable, or a structured table of records, with its purpose and data date clearly labeled.

A practical build sequence is:

Decide who will use the report and write down the questions each audience needs answered.
Prepare and check the source table, including category names, dates, and numeric fields.
Create a PivotTable for the top-level measures and a PivotChart if a visual comparison helps.
Add lower-level fields, such as Store beneath Region, when users genuinely need to inspect that breakdown.
Use a separate detail sheet for individual records, and explain how readers can reach it.
Test the report with different filters and check that totals match the source.

On Excel for Mac, PivotTables and charts are available, but ribbon layout and some controls can differ from Windows. Excel for the web also supports many PivotTable tasks, though its interface and feature coverage are not identical to the Windows desktop application. If the workbook depends on a specific command or data connection, verify it in the version your audience will use.

Add filtering and drill-down carefully

Slicers provide clickable filters for PivotTables. Select a PivotTable and choose PivotTable Analyze > Insert Slicer, then select fields such as Region or Product Category. A timeline can be inserted for date filtering when the PivotTable contains a suitable date field. Keep the controls understandable: a dashboard with many slicers can become harder to use than a well-designed report with a few clear filters.

When multiple PivotTables are based on compatible source data, a slicer may be connected to more than one. Select the slicer and use Report Connections (called PivotTable Connections in some Excel interfaces) to choose the PivotTables it should control. The tables generally need to share the same PivotTable cache or compatible data model. If a target PivotTable does not appear in the list, check how it was created rather than assuming the slicer is broken.

PivotTables can also let readers expand or collapse grouped fields. Depending on the layout, users can use the expand and collapse buttons beside row labels to move between levels. Double-clicking a summarized value can display the records behind that value in a new worksheet for many ordinary PivotTables. This behavior depends on the data source and connection; it is not a substitute for permissions, and it may not be available for every external or OLAP source.

Design for the people reading the dashboard

A multi-level workbook should make its structure visible. Label the summary and detail sheets plainly, use consistent units and date ranges, and show which filters are active. If a chart is filtered to one region, its title or nearby text should make that scope apparent. Readers should not have to guess whether a blank chart means no results, a filter, or a broken connection.

Keep the most important numbers near the top of the summary view, and avoid presenting too many charts that repeat the same information. Use color consistently, but do not rely on color alone to communicate status. A short note explaining definitions—such as whether “sales” includes returns—can prevent disagreements that a more elaborate chart cannot solve.

Also distinguish navigation from security. Hiding a worksheet or protecting cells can help prevent accidental edits, but it does not make confidential data safe from a recipient who can access the workbook. If readers must not see lower-level records, do not distribute those records in an accessible sheet and rely on a slicer or hidden tab to conceal them. Use an appropriately controlled data source or reporting system for access restrictions.

Common problems and how to address them

One frequent issue is a dashboard that does not update after new records are added. If the source is an Excel Table, confirm the new records are inside the table, then refresh the PivotTable using Data > Refresh All. Refreshing updates the report from its source; it does not repair incorrect source values or guarantee an external connection is available.

Another issue is totals that appear duplicated or inconsistent. Check whether the value field is being summed, counted, or summarized in another way, and inspect the source for duplicate records. A field containing text-formatted numbers may not behave like a numeric measure. Similarly, unexpected categories often point to extra spaces, spelling variations, or blanks in the source data.

Readers may also mistake a filtered summary for the full dataset. Label filters, include a clear “all” option where appropriate, and test combinations that return no records. If a slicer controls only some charts, check its Report Connections and whether the PivotTables share a compatible source. Finally, avoid inserting formulas or manually edited totals into the middle of a PivotTable output: those cells can shift or be overwritten when the PivotTable refreshes.

Excel dashboards compared with alternatives

Excel is a reasonable choice when the audience already works with spreadsheets, the data volume and refresh needs are manageable, and users need flexible analysis in a familiar file. PivotTables are especially useful for exploring structured records without building every subtotal manually. Excel also makes it easy to combine a visual summary with notes, tables, and workbook-specific calculations.

A workbook can become inconvenient when many people need simultaneous access, data refresh must be centrally governed, or viewers need tightly managed, role-specific access. Microsoft Power BI is designed for publishing and sharing interactive reports, but it involves a different authoring and sharing workflow. Other business intelligence products may suit particular organizations. The choice depends on data sources, licensing, governance, and who must maintain the report; a larger platform is not automatically better for a small, stable workbook.

Frequently Asked Questions

Does Excel have a feature called “Other Levels”?
No standard Excel dashboard command or feature is named “Other Levels.” The phrase usually needs context. Excel does support reports with multiple levels of detail through PivotTables, grouping, filters, and separate worksheets.

Can one Excel dashboard show company, region, and store results?
Yes. Put those fields in the source data, then arrange them in a PivotTable hierarchy or use slicers to filter the report. Check that the levels are defined consistently and that the chosen view makes the current scope clear.

How do I see the records behind a PivotTable total?
For many standard PivotTables, double-click the summarized value to create a worksheet showing its contributing records. This depends on the source and connection type, and the resulting sheet should be treated as a new detail extract that may need review.

Why does a slicer not control every chart?
The charts may be based on PivotTables that do not share a compatible cache or data model, or the slicer may not be connected to all of them. Select the slicer and inspect Report Connections or PivotTable Connections.

Will a PivotTable include new rows automatically?
A PivotTable needs a refresh to reflect changed source data. Using an Excel Table as its source helps include added rows in the source range, but you still need to refresh the report and verify that the new data was imported correctly.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.