---
schema_version: "1"
id: 5a5bbd248ee11384beafb10c6776559814becd61f04a4a668f065223e0194398
title: "Example: Referencing Total Values of Other KPIs with Different Granularity"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/concept_refrencing_total_values_other_kpis_different_granularity.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.concept_refrencing_total_values_other_kpis_different_granularity.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f094e8a72dd0a3df4d54c694604b6aa9202ecfa07d5bba86f07278c7c3b263e8
description: You can reference the total value of a KPI with a different granularity to calculate the values of a KPI.
products:
  - Consumer Goods
release: "264"
---
# Example: Referencing Total Values of Other KPIs with Different Granularity

You can reference the total value of a KPI with a different granularity to calculate the values of a KPI.

### 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;">
            <p>Available in: Lightning Experience</p>
            <p style="margin-bottom:0;">Available in: <strong>Enterprise</strong> and <strong>Unlimited</strong> Editions where Consumer Goods
              Cloud is enabled</p>
          </td>

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

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/images/icon_example.png)

Example Here are two KPIs:

![Sample KPIs](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/consumer_goods_trade_promo/images/referencing_total_values_other_kpis1.png)

![Sample KPIs](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/consumer_goods_trade_promo/images/referencing_total_values_other_kpis2.png)

Here’s how the product-level values of My Referenced KPI are aggregated to the tactic level.

     
| KPI | Aggregation Level | Total | Week 1 | Week 2 | Week 3 |
| --- | --- | --- | --- | --- | --- |
| My Referenced | Promotion | 930 | 130 | 140 | 660 |
| My Referenced | Tactic 1 | 750 | 100 | 50 | 600 |
| My Referenced | Product 1 | 500 | 100 | 0 | 400 |
| My Referenced | Product 2 | 250 | NULL | 50 | 200 |
| My Referenced | Tactic 2 | 330 | 90 | 120 | 120 |
| My Referenced | Product 1 | 180 | 30 | 90 | 60 |
| My Referenced | Product 3 | 150 | 60 | 30 | 60 |

Here’s how My Example KPI is calculated based on the tactic-level values of My Referenced KPI.

     
| KPI | Aggregation Level | Total | Week 1 | Week 2 | Week 3 |
| --- | --- | --- | --- | --- | --- |
| My Example | Promotion | 1.9887 | 0.4060 | 0.4302 | 1.1635 |
| My Example | Tactic 1 | 0.9888 | 0.1333 | 0.0666 | 0.7999 |
| My Example | Product 1 | 0.6666 | (100/750) × 100 = 0.1333 | 0.0000 | (450/750) × 100 = 0.5333 |
| My Example | Product 2 | 0.3222 | 0.0000 | (50/750) × 100 = 0.0666 | (200/750) × 100 = 0.2666 |
| My Example | Tactic 2 | 0.9999 | 0.2727 | 0.3636 | 0.3636 |
| My Example | Product 1 | 0.5454 | (30/330) × 100 = 0.0909 | (90/330) × 100 = 0.2727 | (60/330) × 100 = 0.1818 |
| My Example | Product 3 | 0.4545 | (60/330) × 100 = 0.1818 | (30/330) × 100 = 0.0909 | (60/330) × 100 = 0.1818 |