The Rollups panel sits above the grid in Assortment Plan. It summarizes the choices in your current filter and timeframe in tabs of KPI tiles, tables and charts. Use it to see how the assortment is doing against plan, last year and your Merchandise Plan without leaving the plan.
Use Cases
Start from the standard Toolio tabs, such as Overview and Reconciliation, and duplicate them to make your own.
Keep a shared Overview of sales, margin, receipts and inventory against plan.
Reconcile your Assortment Plan against the Merchandise Plan, metric by metric and month by month.
Track the season in-season: performance to date, the last few weeks, and top and bottom styles.
Answer a one-off question with a widget, then open it in Reporting to dig further.
Turning the Rollups Panel Off or On
The Rollups panel is on for every organization. To hide it for your whole organization, turn it off in Assortment Plan Settings:
Click your initials in the top right corner and choose
Settings.In the left menu, under
Module Settings, expandAssortment Plan.Click
Assortment Plan Settings.In the
Rollups Panelsection, turn offRollups Panel Enabled.Click
Save.
Turn it back on the same way. Open Assortment Plan, or click the refresh button on a plan that is already open, to see the change. Users who can edit Assortment Plan Settings can change this setting. If you can't, ask your admin.
While the panel is off, Assortment Plan shows the earlier rollups bar above the grid instead. See Assortment Rollup.
Opening the Rollups Panel
In Assortment Plan, click Rollups in the toolbar. The panel opens above the grid on its first tab.
Everything in the panel reports on the same choices and weeks as the grid: the dataset the page last ran, with the grid's current filters, including filter changes you have not saved to the dataset. When you pick another dataset, click the refresh button on the page. The widgets update together with the grid.
Click the expand icon in the top-right corner of the panel to view it full screen. Click Rollups again to close the panel.
Share a Tab With a Link
The open tab is part of the page's link. Click Copy Link to Page, or copy the address from your browser, while the panel is open on a tab. Whoever opens the link lands on Assortment Plan with the Rollups panel open on that tab. If the tab is private to you or hidden for them, the panel opens on its first tab.
Working With Tabs
Each tab is a page of widgets. Changes to tabs and widgets save automatically, and a short message confirms each one, for example Season Scorecard saved. A tab's description shows at the top of the tab, next to an info icon. Hover over a tab and click its ⋮ menu to manage it.
Toolio Tabs
Toolio tabs are standard tabs that Toolio sets up for every organization: Overview, Product Mix, Buy Plan, Reconciliation, Season to Date and Forward Look. They show a Toolio mark before their name and always come first in the tab strip.
Toolio tabs are read-only. Their menu offers
DuplicateandHide for me, and their widgets offerCopyandOpen in Reporting.Toolio keeps them up to date, so they can change over time.
To make your own version, click
Duplicate. The copy is your own private tab, and you can change it freely.Widgets that group by the product hierarchy use your organization's own levels and names. Product Mix, for example, groups by your most detailed level, so its widgets read Mix by Class or Mix by Sub Category, depending on your hierarchy.
Tab Permissions
Every other tab has a permission, shown by the icon before its name. Hover over the icon to see it. These are the same permissions as saved views in the grid.
Permission | Who sees it | Who can change it |
| Everyone | Its creator, admins and users who manage views |
| Everyone | Everyone |
| Only its creator | Only its creator |
Tabs are grouped in that order, after the Toolio tabs. Toolio and Public - Restricted tabs keep their places, so the panel always opens on the same standard tabs. Public and private tabs can be moved within their group.
To change a tab's permission, click Change permission in its menu. Admins can manage these permissions for the whole organization in Settings, under View Permissions (Assortment Plan - Rollups).
If you can't change a tab, its menu offers Duplicate and Hide for me, and you can't add, move or paste widgets on it.
Add a Tab
Click + at the end of the tab strip, enter a Tab name and click Add. The new tab opens empty, ready for widgets.
Rename and Reorder
Click Rename, type the new name and click Rename. Click Move left or Move right to change the tab's position within its group.
Edit Description
Click Edit description to add a short note about what the tab shows, up to 500 characters. Hover over a long description to read it in full.
Duplicate
Click Duplicate to copy the tab with all of its widgets and its description. The copy is added at the end of the strip. A copy of a Toolio tab is a private tab.
Hide a Tab
Click Hide for me to remove a tab from your tab strip. It is hidden only for you; everyone else still sees it. To bring it back, click the ⋮ button next to +, which lists your hidden tabs, and click Show followed by the tab's name, for example Show Overview.
Delete
Click Delete and confirm. The tab and its widgets are deleted permanently. Toolio tabs can't be deleted; hide them instead.
Adding a Widget
Open a tab and click
Add Widget.Pick a
Display:Number,Table,Pie Chart,Bar ChartorLine Chart.Enter a
Title.Pick a
Metricand itsVariants. ClickAdd Metricto add more rows. A new row starts with the previous row's variants.Set the grouping and time options below.
Click
Previewto see the widget before you add it.Click
Add.
Click ? in the dialog header to open this article.
Preview
Click Preview in the dialog footer to open a preview beside the form. It shows the widget exactly as it will look on the tab, with the panel's current dataset, filters and weeks. The preview updates a moment after you stop changing the form. Until you pick a metric, it says Pick a metric to see the widget.
Previewing saves nothing. Click Hide Preview to close it, or Cancel to leave without saving.
Display
Numbershows one tile per metric. The first scenario variant, such asActorPlan, is the headline value. Each other scenario variant shows as a comparison, for example ▼ 8% vs Plan. Variance and share variants show their own value.Tablewithout a grouping and withTotalshows metrics as rows and variants as columns. This is a good layout for reconciliation.Tablewith a grouping lists one row per group. A time group such asMonthlyadds a column per period under each metric.Pie Chartwith a grouping shows each group's share of the first metric. Without a grouping, each metric and variant pair is a slice, for exampleGross Sales Retail (Act)andGross Sales Retail (Plan).Bar ChartandLine Chartwithout a grouping show each metric over time. With a grouping andTotal, a bar chart compares the groups. With a grouping and another time group, they plot the first metric only, with one series per group.
Metrics and Variants
Pick any metric the widgets can calculate: stored metrics plus derived metrics built from simple formulas. Variants include Act, Plan, the last-year variants such as Act LY, Merchandise Plan, variances such as % Var Act vs. Plan, the actualized variants and the shares of the total described below.
Distinct Counts
Distinct SKU Count, Distinct Choice Count, Distinct Style Count and Distinct Location Count count how many different SKUs, choices, styles or locations the widget covers, the same way as in Reporting.
They are available for
Act,Plan,Act LYandPlan LY, their variances and their shares of the total.Merchandise Plan,Act / PlanandAct / MPare not available for distinct counts.A total counts each item once. A style planned in several weeks, or in two groups, counts as one style in the total, so a total is not the sum of its rows.
Plancounts every size in a planned choice's size curve.Actcounts only the SKUs that sold.Distinct SKU Countis often higher forPlanthan forAct.
Act / Plan and Act / MP
The actualized variants show where the season is heading: actuals for the weeks that have closed, and the plan for the weeks still to come.
Act / Planuses actuals for the closed weeks andPlanfor the rest. It is the same asAct / Planwhen you turn onActualizein the grid.Act / MPuses actuals for the closed weeks and the Merchandise Plan for the rest.
The weeks that count as closed are the same as for To Date: up to last week, or up to this week if your organization counts the current week in to-date columns. A closed week without sales counts as zero, not as its plan.
Compare them with these variances, or with their Var versions in units or dollars:
% Var Act / Plan vs. Act / MPshows whether the assortment is on track to land on the Merchandise Plan.% Var Act / Plan vs. Planshows how far the season has moved from the original plan.% Var Act / Plan vs. Act LYcompares the expected season with last year.
Order of Metrics and Variants
To change the order of the metrics, drag a metric row by the handle on its left. The handle shows when the widget has more than one metric.
Click Variants to open the variant list. It is the same list as Variants in the grid's view menu: search at the top, and the selected variants first. Drag a selected variant by its handle to move it, or hover over it and click Move to top.
The order of metrics and variants decides the tiles, the table columns, the chart series and the headline of a Number tile. In a Table, all metrics share one variant order: when you reorder one metric's variants, the same variants move in the other metrics too.
Share of Total
% of TTL and % of Grand TTL show each group's share of a total, like the columns of the same names in the planning grid. Both are available for Act, Plan, Act LY, Plan LY and MP, for example Plan % of Grand TTL.
% of Grand TTLis a group's share of all the widget's groups.% of TTLis a group's share of its parent group. WithGroup Byset to Division and Class, the Men · Tops row shows its share of Men. With a single grouping, it is the same as% of Grand TTL.
A Top setting does not change the total. The groups you see keep their share of all groups, so they don't need to add up to 100%. Pie Chart widgets offer % of Grand TTL only, because a pie shows one whole.
Group By
Pick one or more attributes, such as Category, Color or Style No, to split the widget into one row, bar or slice per group.
Time Group
Time Group decides which weeks the widget totals and how it buckets them. The Choosing a Time Group section below explains each option.
Top
With a grouping, pick Top 5, Top 10 or Top 25 to keep the highest groups, or Bottom 5, Bottom 10 or Bottom 25 to keep the lowest. Then pick the metric in Sort by and its Variant. The sort metric does not need to be one of the widget's metrics.
Groups with no data in the sort variant are left out, so a Bottom 10 list doesn't fill up with empty rows. If no group has data yet, the widget lists them all.
Width and Height
Width is 1 column, 2 columns or Full row. Height is 1 row, 2 rows or Full height. Taller widgets let shorter ones stack beside them.
Choosing a Time Group
Time group | What the widget totals |
| One bucket per retail week, month, quarter or half in the timeframe |
| The dataset's whole timeframe |
| The dataset's timeframe up to the last closed week |
| The last closed weeks before this week |
| The current week |
| The weeks after this week |
| The current retail month, quarter, half or year up to the last closed week |
Every option below Total reports over its own weeks instead of the dataset's timeframe; the dataset's filters still apply. These widgets show a badge next to their title, such as To date, L4W or MTD. Hover over the badge to see the exact weeks.
Number and Pie Chart widgets offer Total and the options below it. Line Chart widgets offer the weekly to half-yearly options and Total. The options below Total are available on retail (week-based) calendars.
To Date
To date cuts the dataset's timeframe at the last closed week, so actuals, plan and last year compare over the same weeks. If your organization counts the current week in to-date columns, the current week is included too.
This matters in-season. Total adds up the whole timeframe, including weeks that have not happened yet, so plan and last year count weeks that have no actuals. A season can read as far behind plan on Total while it is close to plan on To Date.
A timeframe that is already over is totaled in full.
A timeframe that has not started yet, such as next season's dataset, has no closed weeks to total. The widget says so and suggests
Total, which reviews a plan before its season starts.
Rolling Weeks
Last Week and Last 4/8/13 Weeks count closed weeks back from this week, the same way as the LW to L13W columns in the planning grid. This week never counts. They give a recent trend that does not depend on the dataset's timeframe.
Month, Quarter, Half and Year to Date
These run from the first week of the current retail period up to the last closed week, the same way as the MTD to YTD columns in the planning grid. The last closed week is last week. If your organization counts the current week in to-date columns, the current week is included too.
Managing Widgets
Click a widget's ⋮ menu to manage it.
Editopens the widget in the same dialog you added it with.Saveturns on once you change something. To keep the original widget, click the arrow next toSaveand chooseSave as New Widget: your changes go to a new widget at the end of the tab. If you didn't change the title, the new widget's title ends in (copy).Duplicateadds a copy to the same tab.Copyremembers the widget. Right-click an empty area of any tab and clickPasteto add a copy there.Open in Reportingopens Reporting in a new tab with the widget's dataset, filters, grouping, metrics and variants. Nothing is saved until you save a view there.Deleteremoves the widget permanently after you confirm.
To reorder widgets, drag a widget by its header and drop it in its new place.
Long and Wide Tables
A Table widget shows as many rows as fit on the card. When there are more, click +N more rows below the table to see them all, then scroll inside the table. Click Show less to collapse it again. A collapsed table doesn't scroll, so scrolling over it moves the panel.
When a table has more columns than fit, an arrow shows at the right end of its header. Click it, or scroll sideways, to see the rest.
Filter a Table
On a Table widget, click Quick Filter (the search icon next to ⋮) and type. The table shows only the rows whose name contains every word you type, so men tops finds Men · Tops. The filter works on the rows the widget shows, after Top, and it isn't saved with the widget.
Open in Reporting
Reporting opens with the widget's time group, or on exactly the widget's weeks for To Date, the rolling weeks and the periods to date. A Top setting carries over as the sort; Reporting lists every group in that order.
Act / Plan opens as Plan and Act / MP as Merchandise Plan. Turn on Actualize in Reporting to see the same numbers as the widget.
Reading the Numbers
A dash (
—) means there is no value: the variant has no data for the choices and weeks the widget covers, or a percent variance has a base of zero. Hover over an empty tile to see why and which other variants have data.∞%means a percent variance is 100 times the base or more. This usually means the base is close to zero.
Using Tooli With the Rollups Panel
With the panel open, you can ask Tooli about your widgets, have it check them for problems, and have it add or change widgets on your own Private tabs. Tooli shows each new widget or change as a proposal at the top of the panel, and nothing is saved until you click Apply. See How Do I Build and Check Rollups Widgets with Tooli? in the Tooli collection.
FAQs
Why Don't I See the Rollups Button?
Someone in your organization turned the Rollups panel off. Turn on Rollups Panel Enabled in Assortment Plan Settings, as described in Turning the Rollups Panel Off or On, then refresh the plan.
Why Does Act Look Far Behind Plan on My Overview?
A widget on Total adds up the whole timeframe, including future weeks that only have plan and last year. Switch the widget's Time Group to To Date (timeframe so far) to compare the same elapsed weeks.
Why Is My Month to Date Widget Empty?
In the first week of a month there is no closed week in that month yet, unless your organization counts the current week. The same applies to quarters, halves and years. Hover over the badge to check.
Why Does To Date Say the Timeframe Has Not Started?
The dataset's timeframe starts after the last closed week, for example when you are planning next season. Use Total to review a plan before its season starts.
Why Can't I Change a Toolio Tab?
Toolio tabs are standard tabs that Toolio keeps up to date for every organization. Click Duplicate to get your own private copy, and change that instead.
How Do I Get a Hidden Tab Back?
Click the ⋮ button next to + at the end of the tab strip. It lists the tabs you have hidden. Click Show followed by the tab's name to bring it back.
Why Didn't My Widgets Change When I Picked Another Dataset?
Widgets follow the dataset the page last ran, like the grid does. Click the refresh button on the page to apply the new dataset.
