Add and manage columns
Learn how to shape the grid around your analysis by adding calculation and measure columns, applying number formats, and checking formulas in the FX bar. You'll also see how to resize, hide, duplicate, or delete columns, and save the view as a favorite to keep your changes.
Supporting documentation
Related video tutorials
Customize columns
Learn how to add, rename, and hide total, sum, and variance columns, each with its own data stream and period. For example, combine actuals with the remaining budget to build a forecast, then compare it with your full-year budget. Save the result as a custom layout, favorite, or dashboard item.
Edit a dashboard
Learn how to shape a dashboard in edit mode, if you have permission to edit it. You'll add sections with preset or custom layouts, add and manage widgets, split a dashboard into tabs, and format its appearance. Your changes stay private until you publish them, and each publish saves a revision you can restore.
See margin next to every sale
Learn how to see what you made, not only what you sold, by adding profit and margin next to sales in Analytics. Spot a dip in margin percentage over time, break it down by customer and month, and sort to find customers with negative margin. Then drill into the transactions behind them to help reps focus on worthwhile accounts and catch a bad discount early.
Stop losing stock to silence
Learn how to catch dead stock before it ties up cash and warehouse space. You'll filter for products with stock on hand but no sales, sort to find the biggest outliers, and build an inventory turns calculation you can duplicate for other periods. Save any result as a favorite, add it to a dashboard, or create an alert.