Add levels (grid nesting)

Learn how to use conditional formatting to quickly highlight key values in the grid. In Flex Modes, you can apply rules that change the text or background color based on cell values. It’s a great way to make trends and outliers stand out without needing to sort or filter. 

With the nest view feature in Flex Modes, you can add dimensions as levels in the grid, making your data easier to interpret. This lets you see how different items contribute to the overall results and build reports where you define the hierarchy of the data on display.

 

Adjust the standard view of a budget or forecast worksheet to fit your analysis and reporting needs. Depending on your access, some rows may be hidden, but you can still tailor the layout in several ways to suit your preferences.

Looking for a different perspective? In this video, discover options like "Show Others," "Show Average," "Hide Total," "Totals as Average," and "Show Net Zero." These one-touch features make it easy to explore your data in new ways and satisfy your curiosity.