---
schema_version: "1"
id: 795f098fac24aac6b4265ed880ad6811605bd42a1097aee8a9598094964e03cb
title: Set Up the Leader Dashboard in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_dashboard_leader.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_dashboard_leader.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 014554a134c7153f1b7a451f7f05fb1aa42af11f97dd4f47e9ffae5c5b013bd1
description: Show sales managers their teams' performance at a glance with the default Leader Dashboard in Salesforce Spiff. To get started, turn on the dashboard from Spiff company settings. Then, create a quota amount calculation and quota attainment calculation in your plan commission logic.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Set Up the Leader Dashboard in Salesforce Spiff

Show sales managers their teams' performance at a glance with the default Leader Dashboard in Salesforce Spiff. To get started, turn on the dashboard from Spiff company settings. Then, create a quota amount calculation and quota attainment calculation in your plan commission logic.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d68641e76">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d68641e76 ">To set up the Leader Dashboard:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d68641e76 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with these permissions turned on.</p>
              <ul>
                <li>Leader Dashboard: View</li>

                <li>Designer Configuration: Manage</li>

              </ul>
            </td>

          </tr>
        </tbody>
      </table>

![Leader Dashboard example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_dashboard_leader.png)

This dashboard calculates the total attainment of a team and the individual attainment percentage for each team member.

- Team members' combined quota and attainment totals in company currency (1).
- Relative team rankings (2), if cross-team comparison is turned on.
- Comparison of current attainment per day versus projected attainment for the entire quota period (3). Current attainment is divided by the number of days that have elapsed in the quota period. Projected attainment is the current attainment multiplied by the number of days that remaining in the quota period.
- Options for exporting the Team Performance table (4) and switching the Team Performance view between currency and attainment percentage (5).

The person viewing the dashboard sees only the data that they have permission to access. For example, team leads see data for only the teams that they lead. If they have access to multiple teams or quotas, they can filter the dashboard view. Admins see data for all teams.

## Complete Prerequisites for the Leader Dashboard

1. In your Spiff company settings, select **Leader Dashboard** and turn on **Enable Leader Dashboard**.
    
    ![Turn on Enable Leader Dashboard in Spiff company settings](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_dashboard_leader_enable.png)
2. To show team comparison and rankings in the dashboard, turn on **Cross-team comparison**.
3. Make sure that you’ve configured at least one team with a team lead who has a manager role.
    
    Team leads can see only the teams that they lead. See [Create a Team and Manage Team Members Manually in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_teams_create_manual.htm&release=264.0.0&type=5 "Create a team and assign team members from the Teams page in Salesforce Spiff. You can create team hierarchies by creating subteams. You can also assign users as team leads to allow them to view team member statements and easily enable rollouts.").
4. Make sure that the team’s members belong to an active plan that’s visible and that has commission statements generated.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_note.png)
    
    Note If the plan is hidden, the Leader Dashboard doesn’t work correctly.

## Review Calculation Requirements

Next, because the dashboard calculates attainment, create two worksheet calculations that provide numbers used in the dashboard calculation: a quota amount in currency and an attainment amount in currency.

Before you create the calculations, review these important requirements.

- Each calculation must be used in commission logic for one plan.
- Each calculation must be new or exclusive to one plan.
- Each calculation must return an amount in currency, not a number or percentage. We recommend that you use your company's corporate currency.
- To prevent any potential issues with the dashboard affecting commission rules, we recommend that you create a ghost rule for each calculation.

## Create the Quota Calculation

1. Set up a monthly, quarterly, or yearly quota table. See [Set Up a Quota Table](https://help.salesforce.com/s/articleView?id=sales.spiff_quotas_tables.htm&release=264.0.0&type=5 "Specify how you want to format values in a quota table in Salesforce Spiff. Update the table's name or cadence.").
2. Create a quota worksheet calculation that's new or exclusive to the current plan. Follow this pattern and use the `quota()` function to return a value in currency.
    
    ```
    =if(PlanName = "Plan Name", quota("Quota Name"), null)
    ```
    
    For Plan Name and Quota Name, enter the exact names, including double quotes.
    
    ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_important.png)
    
    Important This formula returns `null` if you’re using any other plan. Don’t reuse a quota calculation that’s used with other plans. You can copy and paste formulas from other worksheets.
    
    ![Quota worksheet calculation](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_dashboard_leader_quota.png)
3. With the calculation highlighted, expand the Data Tagging section in the right panel.
4. For tag, select **Quota**.
5. For Quota Cadence, match the length of your quota, but not necessarily the same length as your quota table.
    - If you have a monthly quota table where each month represents a full annual quota, select the **Yearly** option. The dashboard calculates projected attainment based on the length of the quota period.
    - If you have a monthly quota where each month represents one-twelfth of an annual quota, the dashboard shows that one-twelfth amount. To see the total annual quota on the dashboard, use the `quotas()` function instead.
6. Repeat these steps for any other required quota calculations.

## Create the Attainment Calculation

1. Add a worksheet calculation that's new or exclusive to the current plan and that returns reps' quota attainment in currency for a specific period.
    
    For example, if a rep has closed a certain amount in ARR year-to-date, use the `sum()` function to add all ARR\_\_c values from a ClosedInYear data filter with a By Rep filter. Return the total ARR closed per rep for the year. Match the data filter time frame to the quota period, such as a closed-in-quarter data filter for a quarterly quota. If you’re using a monthly quota table to represent an annual quota amount, use a data filter that returns deals from the whole year.
    
    ```
    =if(PlanName = "Plan Name", sum(ClosedInYear!ARR__c), null)
    ```
    
    For Plan Name, enter the exact name, including double quotes.
    
    ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_important.png)
    
    Important This formula returns `null` if you’re using any other plan. Don’t reuse a quota attainment calculation that’s used with other plans. You can copy and paste formulas from other worksheets. Don’t use an attainment percentage calculation. Because the dashboard calculation requires a currency value, don’t convert an existing attainment calculation that returns a different data type, such as a number or percentage, to currency.
    
    ![Quota attainment worksheet calculation](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_dashboard_leader_quota_attainment.png)
2. With the calculation highlighted, expand the Data Tagging section in the right panel.
3. For tag, select **Attainment**.
4. From the Attainment Tag dropdown menu, select the `quota()` function that you previously created and tagged.
    
    Selecting this option makes sure that the dashboard connects the attainment amount to the correct quota amount.
5. Repeat these steps for any other required attainment calculations.

If you also use these quota and attainment calculations in commission calculations, recalculate affected commission statements. Skip the remaining steps to create ghost rules.

If you don’t use these quota and attainment calculations in commission logic, complete the remaining steps to create a ghost rule for each calculation.

## Create Ghost Rules

If you don’t use these quota and attainment calculations in commission logic, create a ghost rule for each calculation so that the calculations are available in reports. A ghost rule makes sure that the calculations don’t cause issues with standard commission rules.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_note.png)

Note Reports in Spiff pull data from calculated statements. A calculation can exist in a worksheet or datasheet in Designer but not be available for reports. For the calculation to be available in reports, use the calculation on a statement or included in commission logic.

1. In a worksheet, create a Payout Amount calculation that contains all the tagged quota and attainment calculations.
    
    ```
    =if(WorksheetName!QuotaCalculationName, 0, 0) + if(WorksheetName!AttainmentCalculationName, 0, 0)
    ```
    
    ![Tagged quota and quota attainment calculations in a ghost rule](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_dashboard_leader_ghost.png)
2. With the Payout Amount worksheet calculation highlighted, turn on **Ghost Rule** in the right panel.
3. Recalculate all affected commission statements.

The Leader Dashboard is available under the Reporting tab for managers and admins.

#### See Also

- [Hidden Plans in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_plans_hidden.htm&release=264.0.0&type=5 "In Salesforce Spiff, create plans that are visible only to certain users so that you can generate reports, experiment with new rules, perform mid-year changes, or prepare plans in advance.")
- [Set Up a Quota Table](https://help.salesforce.com/s/articleView?id=sales.spiff_quotas_tables.htm&release=264.0.0&type=5 "Specify how you want to format values in a quota table in Salesforce Spiff. Update the table's name or cadence.")
- [Considerations for Ghost Rules](https://help.salesforce.com/s/articleView?id=sales.spiff_rules_ghost.htm&release=264.0.0&type=5 "Ghost rules are payout rules where the output doesn’t contribute to a rep's total commission amount for a statement period. Ghost rules are helpful in situations where you want to start building or testing rules for the next quarter or year, or when you want to perform mid-year plan changes.")
- [quota](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_quota.htm&release=264.0.0&type=5 "Returns a quota value from a quota table in Salesforce Spiff. To sum values across multiple reps for a specific quota, use the quotas() function instead.")
- [quotas](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_quotas.htm&release=264.0.0&type=5 "Returns a list of quota values from a quota table in Salesforce Spiff. The quota values are for a specific user in a specific time period.")
- [sum](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_sum.htm&release=264.0.0&type=5 "Calculates a total value from a list of numbers in Salesforce Spiff. This function works well with records in a data filter.")