Add a new column to the grid to show target performance
1:49 min
In this video you'll learn how to add a column to the Phocas grid to show a variance between sales and budget, to see how sales reps are tracking against their budget. We do this using custom mode.
Supporting documentation
Related video tutorials
Analytics Customize column formatting
This video shows you how to format the measures in a particular column, so the data appears just how you want to see it. Use custom mode to add dollar signs to your data - in just one column on the grid, or as many as you like.
1:00 min
Analytics Forecast months of stock on hand (custom mode)
Here we show you how to build a stock report that tells you many months' worth of stock is left based on the average quantity sold compared with stock on hand. We do this by adding a new column containing a couple of simple calculations.
2:18 min
Financial Statements Create a nested view of your financial statement
Here David shows the simple drag and drop steps involved in creating a nested Profit & Loss statement to present a visual comparison of data and drill deeper into cost centre contributions across regions.
4:52 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