---
schema_version: "1"
id: c1a82b093c25f63bcd3df57bc4b37b23a3fd0b4b64a3af21cc7612e245979c51
title: Aggregate Payouts by Product and Member (Example)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/admin_rebates_aggregate_by_product_and_member.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.admin_rebates_aggregate_by_product_and_member.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9226a38443b5e16a9e01dccdca8b29c3412d3c7bd68878097118bb2a112b84e9
description: This example shows how you can use the Aggregate by Product and Member template to aggregate transaction records for a program member for two products.
products:
  - Partner Cloud
  - Cross Cloud
  - Manufacturing
release: "264"
---
# Aggregate Payouts by Product and Member (Example)

This example shows how you can use the Aggregate by Product and Member template to aggregate transaction records for a program member for two products.

### 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: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions that have Rebate Management enabled.</td></tr></tbody></table>

## Transaction Journal Records

Acme is a member of a rebate program. Here are sample transaction journal records for Acme for January 2021.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:20%">
          <col style="width:20%">
          <col style="width:20%">
          <col style="width:20%">
          <col style="width:20%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9407e76">Member</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9407e79">Product</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9407e82">Transaction Quantity</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9407e85">Product Unit Price</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9407e88">Transaction Amount</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Member" class="slds-cell-wrap" rowspan="6" style="vertical-align:top;" headers="d9407e76 ">
              <p style="margin-bottom:0;">Acme</p>
            </td>

            <td data-label="Product" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e79 ">Radius</td>

            <td data-label="Transaction Quantity" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e82 ">5</td>

            <td data-label="Product Unit Price" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e85 ">$100</td>

            <td data-label="Transaction Amount" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e88 ">$500</td>

          </tr>
          <tr class="">
            <td data-label="Product" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e79 ">Radius</td>

            <td data-label="Transaction Quantity" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e82 ">4</td>

            <td data-label="Product Unit Price" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e85 ">$100</td>

            <td data-label="Transaction Amount" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e88 ">$400</td>

          </tr>
          <tr class="">
            <td data-label="Product" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e79 ">Spectra</td>

            <td data-label="Transaction Quantity" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e82 ">7</td>

            <td data-label="Product Unit Price" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e85 ">$120</td>

            <td data-label="Transaction Amount" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e88 ">$840</td>

          </tr>
          <tr class="">
            <td data-label="Product" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e79 ">Spectra</td>

            <td data-label="Transaction Quantity" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e82 ">2</td>

            <td data-label="Product Unit Price" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e85 ">$120</td>

            <td data-label="Transaction Amount" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e88 ">$240</td>

          </tr>
          <tr class="">
            <td data-label="Product" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e79 ">Compass</td>

            <td data-label="Transaction Quantity" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e82 ">10</td>

            <td data-label="Product Unit Price" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e85 ">$60</td>

            <td data-label="Transaction Amount" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e88 ">$600</td>

          </tr>
          <tr class="">
            <td data-label="Product" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e79 ">Compass</td>

            <td data-label="Transaction Quantity" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e82 ">4</td>

            <td data-label="Product Unit Price" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e85 ">$60</td>

            <td data-label="Transaction Amount" class="slds-cell-wrap" style="vertical-align:top;" headers="d9407e88 ">$240</td>

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

## Eligibility Criteria

The rebate program offers a revenue-based rebate type. The program has 12 monthly payout periods.

For the revenue-based rebate type, the program manager defines the eligibility criteria to include transactions for Radius and Spectra products.

## Benefit Tiers

The program manager creates these benefit tiers for the revenue-based rebate type:

- Tier 1: Offers no rebate when the transaction amount is less than $500 for Radius.
- Tier 2: Offers a $200 rebate when the transaction amount is between $501 and $900 for Radius.
- Tier 3: Offers a $500 rebate when the transaction amount exceeds $901 for Radius.
- Tier 4: Offers a $400 rebate when the transaction amount is between $501 and $1500 for Spectra.
- Tier 5: Offers a $600 rebate when the transaction amount exceeds $1501 for Spectra.

## Data Processing Engine

The Transaction Journal records are filtered based on the eligibility criteria for each rebate type. For example, the two transaction records for Compass aren’t considered for calculation. The definition then aggregates quantity and amount values for Radius and Spectra separately and updates records in the Rebate Member Product Aggregate object. For each payout period, two aggregate records—one for each product—are created for a member.

## Aggregate Data

These sample records are created in the Rebate Member Product Aggregate object for January.

      
| Record | Member | Payout Period | Rebate Type | Product | Total Quantity | Total Transaction Amount |
| --- | --- | --- | --- | --- | --- | --- |
| Record 1 | Acme | Jan FY21 | Revenue-Based | Radius | 9 | $900 |
| Record 2 | Acme | Jan FY21 | Revenue-Based | Spectra | 9 | $1080 |

These values update whenever the scheduled flow runs. The flow triggers the data processing engine definition. The aggregate values on the payout calculation date for Jan FY21 are used to update the final payout amounts in the Member Payout object.

## Final Payouts

Acme receives these payouts for the revenue-based rebate type based on the benefit tier they qualified for.

- For Radius, Acme receives $200 because the total transaction amount of $900 matches Tier 2.
- For Spectra, Acme receives $400 because the total transaction amount of $1080 matches Tier 4.