> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gocrisp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Finding top-performing stores

You can generate a list of stores based on their sales, so you can determine the best stores for assortment expansions, partner collaboration, and marketing efforts.

**Note** : This tutorial requires that you have access to Microsoft® Excel.

**Steps** :

1. From the main menu on the left side of the screen, select **Analytics**.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/main_menu_analytics.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=02f3eb78ec00282da45cd933c210aee6" alt="main_menu_analytics.png" width="750" height="508" data-path="docs/support/images/main_menu_analytics.png" />

The Analytics menu appears.

2. Select the sales dashboard for the retailer for which you want to find top-performing stores. In this example, we'll look at the KeHE Explore Sales dashboard.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/finding_top_performing_stores_001.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=c5a6d6e216983a4eb62bc1ae47399578" alt="finding_top_performing_stores_001.png" width="1506" height="640" data-path="docs/support/images/finding_top_performing_stores_001.png" />

3. At the bottom of the page, in the *Sales* *Details* table, click the **Tile actions** button, then select **Download data**.\\
   <img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Finding_Top_Performing_Stores.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=c381ab4eff16ba8984034b00f75e160e" alt="Finding_Top_Performing_Stores.png" width="602" height="458" data-path="docs/support/images/Finding_Top_Performing_Stores.png" />

4. From the *Format* drop-down menu, select **Excel spreadsheet (Excel 2007 or later)**.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Finding_Top_Performing_Stores_002.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=8d080b263a7ed3488d066c61195d946b" alt="Finding_Top_Performing_Stores_002.png" width="902" height="922" data-path="docs/support/images/Finding_Top_Performing_Stores_002.png" />\
**Note** : If you have more than 500 stores, click **Advanced data options** , then in the *Number of rows to include* section, select **All results**.

5. Click the **Download** button.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Finding_Top_Performing_Stores_003.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=3d373b00f911b4aeb3c98ef3b2cdb2a7" alt="Finding_Top_Performing_Stores_003.png" width="926" height="398" data-path="docs/support/images/Finding_Top_Performing_Stores_003.png" />

An Excel spreadsheet opens.

6. Highlight the *Store* column, then hold down the Ctrl key (or command key on a Mac) and highlight either the *Sales Quantity* or *Sales Dollars* column (depending on which metric you want to use to gauge performance).

7. With the two columns highlighted, select the **Analyze Data** button at the top right of the screen. **Note** : This button is only available in newer versions of Excel.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Finding_Top_Performing_Stores_004.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=969560ba6567bb42bcdf0feb5355345e" alt="Finding_Top_Performing_Stores_004.png" width="666" height="300" data-path="docs/support/images/Finding_Top_Performing_Stores_004.png" />\
The *Analyze Data* panel appears on the right side of the screen.

8. From the *Discover insights* section, select **Insert PivotTable.\
   <img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Finding_Top_Performing_Stores_005.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=b8c7b4bce1f97a3c5eddd947dc599426" alt="Finding_Top_Performing_Stores_005.png" width="644" height="648" data-path="docs/support/images/Finding_Top_Performing_Stores_005.png" />**\
   A new tab appears in the spreadsheet with your stores sorted based on the sales column you selected.
