Home Academy Video tutorials

Manage grid settings

2:41 min
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.

Supporting documentation

Phocas product
Category
Phocas Software help and support
Help & support

Have questions or need to report an issue with a Phocas product?

Get support

Related video tutorials

Switch modes
Analytics Analytics

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.

2:32 min
Change the period
Analytics Analytics

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.

2:32 min
Work with the grid
Analytics Analytics

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.

2:54 min
Apply conditional formatting
Analytics Analytics

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.

2:37 min
NewSee the latest features, improvements and what's new in productView product updates