# Pivot table - update format result

**URL:** <https://community.hubspot.com/t/pivot-table-update-format-result/80989>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [May 11, 2023, 8:37am UTC](https://community.hubspot.com/t/pivot-table-update-format-result/80989 "2023-05-11T08:37:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ASAUBLET](https://avatars.discourse-cdn.com/v4/letter/a/5daacb/32.png) [@ASAUBLET](https://community.hubspot.com/u/ASAUBLET)\
**Post date:** [May 11, 2023, 8:37am UTC](https://community.hubspot.com/t/pivot-table-update-format-result/80989/1 "2023-05-11T08:37:19Z")

</div>

The result of pivot table is not optimised. It would be great if :

- when there is no data in the value, let a blanck rather than put a 0.

- for subtotals, put the line in bold or in another color to separate the line from the detail

- modify the display to create block with +/- for each line value which have line below, like in Excel, to be able to hide detail (see below)

 ![ASAUBLET_0-1683793462225.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/d/8d1b72ced4cf6cd72df31af2df55cd03dccc2c6a.png)

---

<div class="post-metadata">

**Author:** ![PODonohue](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@PODonohue](https://community.hubspot.com/u/PODonohue)\
**Post date:** [April 3, 2024, 5:00pm UTC](https://community.hubspot.com/t/pivot-table-update-format-result/80989/2 "2024-04-03T17:00:29Z")

</div>

I agree, the display could made a lot cleaner if they added the ability to collapse and expand the rows with the +/- buttons, also I wish there was a way to edit the width of columns so the headers don’t get cut off