# Formulas within pivot tables

**URL:** <https://community.hubspot.com/t/formulas-within-pivot-tables/83620>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [June 16, 2023, 9:39pm UTC](https://community.hubspot.com/t/formulas-within-pivot-tables/83620 "2023-06-16T21:39:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ShawnM105](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@ShawnM105](https://community.hubspot.com/u/ShawnM105)\
**Post date:** [June 16, 2023, 9:39pm UTC](https://community.hubspot.com/t/formulas-within-pivot-tables/83620/1 "2023-06-16T21:39:29Z")

</div>

I would love to see more flexibility within pivot tables. Something my client was asking for was the ability to show the delta for our total closed deal revenue vs forecast. I’d love the ability to use formulas such as subtracting the sum of one property from the sum of another. Using the attached chart as an example.

![808649_1_Screen Shot 2023-06-16 at 5.38.55 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/7/57dcaa9498053b1ca2372b9550e937e2825ed069.png)

---

<div class="post-metadata">

**Author:** ![ROperations](https://avatars.discourse-cdn.com/v4/letter/r/dec6dc/32.png) [@ROperations](https://community.hubspot.com/u/ROperations)\
**Post date:** [June 20, 2024, 5:56pm UTC](https://community.hubspot.com/t/formulas-within-pivot-tables/83620/2 "2024-06-20T17:56:41Z")

</div>

Agree, would love to have this.