Create a Store or Item Rank based on Retail Sales (RTL SLS) to understand which locations or items are up-trending and driving business in a particular time period. The Rank metric allows for quick insight on top performing Products or Stores. Users can set up the Rank metric in both Collaboration Analytics and Performance Analytics.
Setup Steps:
Right click on the RTL SLS or UNIT SLS metric in the Product or Store level report.
Select Insert Metric → Rank → Break by None → Descending.
Right click on the new Rank metric appended to the report (Rank (TY WTD RTL SLS)) and select Sort → Ascending to order the report by this new rank.
To Condense:
Drag and drop the new Rank metric into the first position after the attributes so that it is the first metric in the report.
Rename the new Rank metric for ease of use.
Right click on the new Rank metric → Edit → Rename → Save
Right click on the newly renamed Rank metric (Top Sales Rank) and select Filter On → Top N... (Top Number).
Enter in the desired amount of products or stores to reduce the report down to.
⛑️ SPS Analytics Support
If you have any additional questions regarding Collaboration or Performance Analytics, please reach out to our Analytics Support team at the contact information below:
☎️ 888-739-3232, Option 2