Compare data in a matrix in Flex Modes

1:37 min

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.

Supporting documentation

Compare data in a matrix

Phocas product

Analytics

Category

Flex Modes

Tags

Grid Format Customize Matrix

Help & support

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

Get support

Related video tutorials

Apply conditional formatting in Flex Modes

Analytics

Apply conditional formatting in Flex Modes

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

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 in Flex Modes

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

Financial Statements

Set up elimination journals

Learn how to set up and post elimination journals in Phocas Financial Statements. This video covers the full elimination workflow, from creating an elimination entity and enabling elimination-only accounts to posting journals in Data Entry. It also shows how eliminations are kept separate from ERP actuals, helping you report clearly while maintaining a clean audit trail.

5:20 min