Work with the grid
Learn how to work efficiently with the grid. You'll sort values, collapse the dimensions panel for more room, freeze property columns while you scroll, page through large result sets, and select values to see their average, count, and sum. You'll also use right-click actions and keyboard shortcuts.
Supporting documentation
Related video tutorials
Switch modes
Learn how to change how data appears in the grid by switching between Period, Variance, Stream, Total, and Transaction modes. You'll also move between Summary and Dimension views, and see how your selections and filters carry across, so you can compare the same analysis in different ways.
Change the period
Learn how to change the period so you can focus on the time frame you want to review. You'll choose from available periods, select a fixed date range, and save a user-defined period with dynamic dates, so it keeps showing the latest months without you recreating it.
Manage grid settings
Learn how to tailor the grid with grid settings. You'll reverse the period order, show items with or without activity, align incomplete periods with Period to Date, and add sparklines, totals, and an Others row. You'll also see how to handle rows that net to zero and change the font size.
Apply conditional formatting
Learn how to highlight key values in the grid with color-based rules, so trends and outliers stand out without sorting or filtering. You'll set conditions such as greater than or less than, choose background colors, and edit or remove rules. Conditional formatting is saved with favorites and carries over when you export to Excel.