new
Assortment Plan
📈 ROS By Choice-Location View
What's new
The ROS Model is critical to setting an initial forecast target, and Calculated ROS is a key input into that process. Until now, you could see the aggregated result but not what went into it. Now, the ROS percentiles dialog includes a "By Choice-Location" tab that lets you drill one step deeper — you can see exactly which choices were included in the calculation and how each one contributed, broken down by location or cluster.
What you can do
- Open the ROS details– Double-click on any Calculated ROS cell in the grid to open the ROS percentiles dialog, then switch to the "By Choice-Location" tab.
- See ROS at the choice-location and choice-cluster level– View ROS, Weeks, and Good Weeks for each choice at each location or cluster.
- Group and filter the data– Use the toolbar to group rows by cluster, source, location, or choice attributes, and filter to narrow down exactly what you're looking at.
- Pick which choice attributes to show– Use the Attributes picker to choose which choice columns (like External ID, Title, Color) appear in the grid.
Why it helps
- Understand the ROS contributions coming from individual choices, broken down by cluster.
- Understand the impact of data cleansing by comparing Gross Sales Units vs. Good Weeks Gross Sales Units.
- Drill into the details behind your Calculated ROS instead of relying only on the aggregated number.