---
title: "Example: Creating a Total Calculated Average Cost Report"
slug: "example-creating-a-total-calculated-average-cost-report"
updated: 2023-09-21T16:01:43Z
published: 2023-09-21T16:01:43Z
canonical: "docs.avontus.com/example-creating-a-total-calculated-average-cost-report"
---

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

# Example: Creating a Total Calculated Average Cost Report

In order to further illustrate how you can customize the pivot grid to produce the data you need, the procedures below show you how to use the Product Pricing pivot to create a report that shows:

- Total Calculated Average Cost along with Quantity Available (if the location is a Branch Office)
- Quantity at Job Site (if the location is a Job Site) for products at a Branch Office

To create a Total Calculated Average Cost report:

1. Locate and click the appropriate Branch Office in the Organization Tree.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311471006.png)
2. Click the **Products** tab, then click the **Reports** dropdown and select **Product Pricing Pivot**.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311479146.png)The *Pricing Pivot* dialog appears, displaying the default layout.  
 ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311551888.png)
3. Click the **Location Type** field and drag it to the left of the **Name** field.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311634748.png)The result should look like this:  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/92949394-c792-49eb-8ad8-179d965875fc.png)
4. Click the **Calculated Avg. Cost Each** field and drag it to the right of the **Description** field.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311659909.png)The result should look like this:  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311694687.png)
5. Click the **Quantity Available** and **Quantity on Rent** fields and drag them to the **Grand Total** section.  
 ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311832877.png)
6. Click the **Quantity on Rent** field and drag it to the right of the **Quantity Available** field.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311916480.png)This rearranges their order in the **Grand Total** area of the dialog..  
The pivot grid should now look like this.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695311936025.png)

You can now save your customized layout for future retrieval. Refer to the *Saving a Customized Pivot Report* section of *[Editing, Saving and Viewing Pivot Reports](/v1/docs/editing-saving-and-viewing-pivot-reports)*.