Skip to main content
All CollectionsHow-to Articles
Create a 'Percent to Totals' Metric for Total Business
Create a 'Percent to Totals' Metric for Total Business

See How Each Store or Product Compares to Total Business in Performance Analytics

Ashley Larson avatar
Written by Ashley Larson
Updated over a month ago

Want to see how a store location or product is doing as an overall percentage, compared to your entire business? Here's how to do it!

πŸ’‘Note: This feature is only available to Power Users.

  1. In Performance Analytics, under the Dashboards folder > Best Practice Reports >

    1. For store metrics, open the Store Ranking Report.

    2. Alternatively, open the Basic Selling Report for product metrics.

  2. Right-click on either the:

    • Retail Sales Integrated (TY WTD RTL SLS-INT) or

    • Unit Sales (TY WTD UNITS SLS) metric

  3. Select Insert Metric > Percent to Total > Over Rows.

    Note: Click on image to enlarge.

  4. Right-click on the newly created metric and Rename it to your liking.

    Note: Click on images to enlarge.

  5. To sort the report by the largest percentage share, right-click Sort > Descending.

  6. Now the best-performing stores will be listed first.

πŸ’‘Extra Credit: Open the Basic Selling Report in the Best Practice Reports folder and follow the above steps to rank it by product performance!


⛑️ SPS Analytics Support

If you have any additional questions regarding Performance Analytics, please reach out to our Analytics Support team at the contact information below:

☎️ 888-739-3232, Option 2

Did this answer your question?