Hide what you don't plan, such as inactive items, a discontinued supplier or a whole package type, so the grid shows only what matters. A bulk change on a row changes only the items you can see, never the hidden ones. An Owner or Admin can make a filter the workspace's default, so everyone opens plans with it.
Anyone who can open a plan can filter it. Making a filter the default needs an Owner or Admin.
Before you start
- A filter works on any grouping from your items import: Supplier, Brand, Package, or a status column you mapped as a grouping. Unit is always offered too, without importing it twice: each item's own unit, such as case, quarter keg or half keg. To filter out inactive items, map your file's status column (Active, Status, Inactive, whatever your system calls it) as a Dimension when you import items (see Import your items). Keep inactive items in the file: their past sales still count in comparisons.
Hide rows by a grouping's values
Open Plans and open the plan.
Next to Filter, open + Filter and choose the grouping, for example Active.
You should see a list of its values under the toolbar, each with how many items hold it, all ticked.
Untick the values to hide, for example 0 or Inactive. For a long list, type in Search first, then Hide these or Show these for every match.
You should see a chip such as Active: hiding 0, and the count above the grid change, for example 1,240 of 3,600 items. Totals add up only what is shown.
Click Done. To change the filter later, click its chip. To remove it, click × on the chip.
Plan one unit at a time
An amount in native units, such as Add 500 cases, needs a selection whose items share one unit. To plan cases apart from kegs, add Unit under Group by, or filter Unit to hide the kegs, then select the row. An amount in equivalent units, such as CEQ, works across units without this.
Hide empty rows
Hide empty rows, next to the filters, is on unless your workspace's default view turns it off. It hides items with no quantity in any month of the plan, of the approved baseline, or of the actuals being compared. A supplier whose items all sell nothing disappears with them, and comes back as soon as anything is planned or sold for it.
Untick it to see every item, for example to plan a new item that has nothing in it yet.
Make it the default view
Set the filters and Hide empty rows the way everyone should see plans.
Click Make this the default view.
You should see Saved. Everyone in the workspace now opens plans with this view.
Anyone can still change the view for themselves: remove a filter, add another, or untick Hide empty rows. Back to default view puts the workspace's default back. The default applies to every plan in the workspace, including ones created later.
What a bulk change does with a filter on
A bulk change applies to the selected row's items as shown. Hidden items are never changed, even when they sit under the selected row. The plan's History records what was hidden, for example Supplier: Acme › Brand: Hazy (hiding Active: 0; rows with no volume). An export downloads the rows as shown, too.
Common mistakes
- Leaving inactive items out of the items import instead. Their sales lines are then rejected, so last year's actuals come out short. Import them, and filter them out here.
- A change didn't reach some items. They were hidden when the change was made. Check the step in History: it says what was hidden. Remove the filter, select the row again and apply the change to them.
- A new item doesn't appear. It has nothing planned yet, so Hide empty rows hides it. Untick it to plan the item (see Start new items in a plan).
- The filter list shows codes such as 0 and 1. That's what the items file holds. Export the column as words (for example Active and Inactive) and import the items again: existing items are updated and plans keep their numbers.