How to customize your data?

Individuals have unique ways of perceiving the world around them. This includes how they extract meaning from their data. Some people prefer to see as much information as possible. While others favor a more simplified report. At Phocas, we pride ourselves on offering flexibility. Here are three videos that demonstrate how to customize your data according to your needs.
See more by freezing the properties column
A wonderful feature of Phocas is the ability to see all of your data in the grid area. However, having several columns on the screen means there is considerable amount of data to scroll through. Freezing properties such as ‘name’ or ‘territory group code’ enables you to scroll as much as you like without losing sight of important reference data.
In this video, we’ve got our grid view with several properties turned on. As we scroll over to our monthly sales, we lose sight of those properties such as the territory group code. But Phocas offers a simple way to freeze properties by simply selecting the snowflake icon at the bottom of the screen. Now we can scroll over to our monthly sales values without losing our properties.
Better understand your customers in percentage share view
Phocas allows users to change the format to compare profitability to sales value. Switching from actual figures to a percentage share view can reveal discrepancies between sales value and profitability. This will provide a much better understanding of your customers.
In this video we will show you how to compare these measures to find the customers who represent a higher sales dollar rations than they do percentage dollar ratio. We do this by selecting our ‘Bill to’ customers. In the total mode we have selected ‘Sales Value’ and ‘Profit Value.’ But if we select ‘Percentage Share’ under the format drop down menu, we have a much different view of our customers. For instance, we see that while a customer represents 9.97% of the total sales value, they only represent 8.4% of the total profit. Changing the format to ‘Percentage Share’ in Phocas offers a clear view of what customers are actually bringing to the table.
More options for displaying data
Want another way of looking at your data? In this video, we learn about the ‘Show Others’, ‘Show Average’ and ‘Hide Total’ display options. To begin, we have five product sub-classes selected but by selecting ‘Show Others’ and additional line called ‘Others’ is added. In our example we can see that in addition to the $55million in sales from the selected product sub-classes, we have $22million in sales of other not included on this page.
By deselecting ‘Show Others’ and selecting ‘Show Average’ we can see the average sales for the five selected sub-classes. In our example of $55million, we can see we have an average of about $10million per line. Finally, by deselecting ‘Show Average’ and selecting ‘Hide Total’, we remove the total line from the top of the page for a simplified view of the sales values for our selected sub-classes.
To better understand all the features of Phocas data analytics, book a demo today.

Empowering businesses with intuitive data analytics, driving informed decisions for growth and profitability. We make people feel good about data.

Financial statement analysis: what's changing?
Financial statements are scorecards for businesses, allowing the finance team to interpret and analyze financial performance.
Read more
Break down data silos and improve business planning
The amount of data generated by finance, sales and operations teams is vast and complex, making it difficult for everyone to work together, plan and make data-driven decisions. The time spent on extracting data from multiple systems, formatting into spreadsheets and then loading into other programs is excruciating, and the time lost doing it, is taking its toll. Welcome to the world of data silos.
Read more
What are your company's most important financial ratios?
Companies that make data-driven decisions do better. While this is a common-sense opening line, you might be surprised at the number of businesses that only look at surface-level data like total sales. We’re not saying that in order to be successful you have to be data-obsessed, but sometimes you have to dig deeper into the data to make those bigger, more impactful decisions. Financial ratio analysis is an effective way to use data from your company’s financial statements, such as balance sheet, income statement, and cash flow statement, to gain vital information about your company’s performance and financial health. Today, we’re going to dive into the important financial ratios that can help you make revenue-generating decisions that get results.
Read more
How to overcome the C-suite’s new dilemma – speed vs accuracy
Now that organizations are restoring some semblance of pre-Covid normality, they find themselves mired in yet more economic and political uncertainty. Against this turmoil, agile forecasting, reporting, and speed are top of mind as CFOs seek to steer their organizations deftly through an unprecedented set of challenges.
Read more
Find out how our platform gives you the visibility you need to get more done.
Get your demo today