Apply conditional formatting
2:22 min
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.
Supporting documentation
Phocas product 
Analytics
Analytics Category
Help & support Related video tutorials
Analytics Compare data in a matrix
Learn how to filter and pivot rows at the same time, letting you view two dimensions side by side in a matrix. This makes it easy to compare your data and quickly spot any differences.
1:37 min
Analytics Add levels to the 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
Analytics Create a nested view
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.
1:54 min
Analytics Create an advanced filter
Learn how to use the Advanced Filter to take your analysis further and answer more complex questions. It’s a powerful way to refine your search results and uncover deeper insights in your data.
3:31 min
Financial Statements 
Budgets & Forecasts 
Rebates 
CRM 