Compare data in a matrix 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. 

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.

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.

 

Learn how to enhance your analysis in Flex Modes by adding custom columns. Whether you’re creating calculation columns to build formulas like percentages and comparisons, or adding measure columns to bring in additional data such as counts, this feature gives you the flexibility to explore your data more deeply and uncover meaningful insights.