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 yesterday

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?