Home Academy Video tutorials

Work with the grid

2:54 min
Work with the grid

Learn how to work efficiently with the grid. This tutorial shows you how to sort data, freeze properties, navigate larger result sets, use grid actions and shortcuts, and quickly calculate values from selected data.

 

Supporting documentation

Phocas product Flex Modes Flex Modes
Phocas Software help and support
Help & support

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

Get support

Related video tutorials

Apply conditional formatting
Flex Modes Flex Modes

Apply conditional formatting

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. 
2:22 min
Change the grid layout
Budgets & Forecasts Budgets & Forecasts

Change the grid layout

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.
2:17 min
Add levels (grid nesting)
Analytics Analytics

Add levels (grid nesting)

Learn how to bring together related data from different dimensions as an expandable report in the Phocas grid using the 'nest' feature. Grid nesting allows you to display up to three levels of detail, grouped by dimension.
1:59 min
Set up a database
Insights Insights

Set up a database

Learn how to configure a database for Customer segmentation in Insights. This tutorial walks through selecting your data, setting segmentation groups, and defining Frequency, Monetary, and Recency thresholds so you can start analyzing customer behavior.

 

 

 

 

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