Change the data format

1:47 min

Learn how switching from actual figures to percentage share view can instantly reveal discrepencies between sales value and profitabilty.

Supporting documentation

Phocas product

Analytics

Category

Customize views

Tags

Format Customize

Help & support

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

Get support

Related video tutorials

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

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

Analytics

Get more options for viewing data

Looking for a different perspective? In this video, discover options like "Show Others," "Show Average," "Hide Total," "Totals as Average," and "Show Net Zero." These one-touch features make it easy to explore your data in new ways and satisfy your curiosity.

2:20 min

Flex Modes

Copy or export data

Learn how to copy or export data from the grid when you want to continue working with it outside Phocas. See how to copy selected cells or rows into a spreadsheet, or export a wider set of data as a CSV or XLSX file. You’ll also see how Excel exports retain features such as conditional formatting and nested rows, helping you carry more of your current view into Excel.

1:47 min