---
title: How Do I Get Attribution Values Within a Specific Period?
description: How to pull Attribution values across a specific time period.
---

[Skip to content](https://www.allocator.com/knowledge/how-do-i-get-attribution-values-for-a-specific-t#main-content)

English

Show submenu for translations

![Allocator_Logo_Colour_Mark.png\]](https://www.allocator.com/hs-fs/hubfs/Branding%20-%20Images%20and%20Logos/Allocator%20logos/Allocator_Logo_Colour_Mark.png?height=40&name=Allocator_Logo_Colour_Mark.png)

- [Knowledge Base](https://www.allocator.com/knowledge)
- [Allocator Platform](https://secure.allocator.com/)
- [Sign out](https://www.allocator.com/_hcms/mem/logout)

Open main navigation

Close main navigation

- [Knowledge Base](https://www.allocator.com/knowledge)
- [Allocator Platform](https://secure.allocator.com/)
- [Sign out](https://www.allocator.com/_hcms/mem/logout)
- English
  
  Show submenu for translations

 Allocator Knowledge Base

- There are no suggestions because the search field is empty.

1. [Allocator Knowledge Base](https://www.allocator.com/knowledge?hsLang=en)
2. [Export Your Data](https://www.allocator.com/knowledge/export-your-data?hsLang=en)
3. [Allocator Excel Add-In](https://www.allocator.com/knowledge/export-your-data?hsLang=en#allocator-excel-add-in)

# How Do I Get Attribution Values Within a Specific Period?

## How to pull Attribution values across a specific time period.

**Formula**

=ALLOCATOR\_ATTRIBUTION\_ARRAY( *\[Text\]* ID, *\[Text\]* Categorization, *\[Text\]* Table, *\[Text\]* Variable, *\[Text\]* Category, *\[Text\]* Mode, *\[Date\]* Start Date, *\[Date\]* End Date, *\[Text\]* Include Funds, *\[Text\]* Level, *\[Text\]* Trim)

**Arguments**

**ID** - Required - *Text -* ***Eg****: fdedb7                            * The Fund, Company, Series, Portfolio ID.

**Categorization** - Hypothetical - *Text                     * How you want the data to be fetched.

**Table** - Required - *Text -* ***Eg****: Long & Short            * The table to load.

**Variable** - Hypothetical - *Text -* ***Eg****: Short              * The type of data you want.

**Category** - Hypothetical – *Text                               * Path to the category you want the value of.

**Mode** - Required - *Text -* ***Eg****: Wide                         * How you want the output ("Wide" or "Narrow").

**Start Date** - Optional - *Date                                    * The start date in YYYY-MM-DD format.

**End Date** - Optional - *Date                                      * The end date in YYYY-MM-DD format.

**Include Funds** - Optional - *Text                              * Include funds or not.

**Level**- Hypothetical - *Text                                        * The level of depth of Attribution.

**Trim**- Optional - *Text                                                * Trim leading and trailing months if no categories other than unexplained are populated.

**Example**

The Geographic Attribution values for fund “fdedb7” for the year 2021.

= ALLOCATOR\_ATTRIBUTION\_ARRAY( "fdedb7","Mapped","Geography","Total", ,"Narrow","2021-01-01","2021-12-31", ,2)

![](https://www.allocator.com/hubfs/image-png-Aug-18-2022-01-52-26-33-PM.png)

**Remarks**

*![](https://www.allocator.com/hubfs/image-png-Aug-18-2022-01-52-38-68-PM.png) \[Category\]* This is Required as long as there are categories available.

![](https://www.allocator.com/hubfs/undefined.png) The date field is not format sensitive if you input a cell reference.

![](https://www.allocator.com/hubfs/undefined.png) If the dates are ignored, **Attribution Array** will return everything without any date restriction.

*![](https://www.allocator.com/hubfs/image-png-Aug-18-2022-01-52-40-58-PM.png) \[Categorization\]* If ID is a Portfolio then Categorization is Ignored and = Mapped**.**

* ![](https://www.allocator.com/hubfs/image-png-Aug-18-2022-01-52-42-38-PM.png) \[Category\]* In case there is no category available, Category is Ignored and = Variable.

** ![](https://www.allocator.com/hubfs/image-png-Aug-18-2022-01-52-45-09-PM.png)** *\[End Date\]* This argument is Ignored if **Mode** = Narrow**.**

 

 

- [Platform Knowledge Base](https://www.allocator.com/knowledge/platform-knowledge-base?hsLang=en#main-content)
  
  
  
  
  
    - [Stay on Top of Your Onboarding](https://www.allocator.com/knowledge/platform-knowledge-base?hsLang=en#stay-on-top-of-your-onboarding)
- [Hedge Funds](https://www.allocator.com/knowledge/hedge-funds?hsLang=en#main-content)
  
  
  
  
  
    - [Calculation Definitions](https://www.allocator.com/knowledge/hedge-funds?hsLang=en#calculation-definitions)
    - [How-To Guides](https://www.allocator.com/knowledge/hedge-funds?hsLang=en#how-to-guides)
- [Private Capital Funds](https://www.allocator.com/knowledge/private-capital-funds?hsLang=en#main-content)
  
  
  
  
  
    - [Calculation Definitions](https://www.allocator.com/knowledge/private-capital-funds?hsLang=en#calculation-definitions)
    - [How-To Guides](https://www.allocator.com/knowledge/private-capital-funds?hsLang=en#how-to-guides)
- [Export Your Data](https://www.allocator.com/knowledge/export-your-data?hsLang=en#main-content)
  
  
  
  
  
    - [Allocator Excel Add-In](https://www.allocator.com/knowledge/export-your-data?hsLang=en#allocator-excel-add-in)
    - [Allocator API](https://www.allocator.com/knowledge/export-your-data?hsLang=en#allocator-api)
- [What's New on Allocator?](https://www.allocator.com/knowledge/whats-new-on-allocator?hsLang=en#main-content)
  
  
  
  
  
    - [Q1 2026](https://www.allocator.com/knowledge/whats-new-on-allocator?hsLang=en#q1-2026)

[![Chill listening crop-3](https://www.allocator.com/hs-fs/hubfs/Branding%20-%20Images%20and%20Logos/Allocator%20logos/Allocator_Logo_Colour%20No%20Background.png?width=171&height=24&name=Allocator_Logo_Colour%20No%20Background.png "Chill listening crop-3")](https://knowledge.allocator.com/knowledge?hsLang=en)

www.allocator.com

<https://twitter.com/Allocator_com> <https://www.linkedin.com/company/hedgepo/>

Copyright © 2026, Allocator