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?
Hi @josef_dipity ,
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, You can upvote it to show your support!