# Show pivot table difference instead of total

**URL:** <https://community.hubspot.com/t/show-pivot-table-difference-instead-of-total/109899>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [June 23, 2024, 1:47am UTC](https://community.hubspot.com/t/show-pivot-table-difference-instead-of-total/109899 "2024-06-23T01:47:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![josef\_dipity](https://avatars.discourse-cdn.com/v4/letter/j/d6d6ee/32.png) [@josef\_dipity](https://community.hubspot.com/u/josef_dipity)\
**Post date:** [June 23, 2024, 1:47am UTC](https://community.hubspot.com/t/show-pivot-table-difference-instead-of-total/109899/1 "2024-06-23T01:47:59Z")

</div>

Hello! I was wondering if there was any way we could get this test/dummy pivot table report to show the difference instead of the total between the “GALLONS SOLD” and “NET PRICE” for the 05-2024 and 06-2024 deals?

 ![josef_dipity_0-1719107225982.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/e/ec6a88db9f06efd6575883f4ff7b940b62be15e9.png)

---

<div class="post-metadata">

**Author:** ![ArisudanTiwari](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/arisudantiwari/32/93919_2.png) [@ArisudanTiwari](https://community.hubspot.com/u/ArisudanTiwari)\
**Post date:** [June 24, 2024, 8:36am UTC](https://community.hubspot.com/t/show-pivot-table-difference-instead-of-total/109899/2 "2024-06-24T08:36:18Z")

</div>

Hi [@josef\_dipity](https://community.hubspot.com/t5/user/viewprofilepage/user-id/782207) ,

Currently, HubSpot doesn’t offer a direct way to subtract the sum of an amount.

Alternative solution:

You can create a custom calculation property in HubSpot to display the desired value.

Rest similar ideas already submitted in the portal [https://community.hubspot.com/t5/HubSpot-Ideas/Formulas-within-pivot-tables/idi-p/808649](https://community.hubspot.com/t5/HubSpot-Ideas/Formulas-within-pivot-tables/idi-p/808649), You can upvote it to show your support!