# How to show totals and values in different format

**URL:** <https://community.amazonquick.com/t/how-to-show-totals-and-values-in-different-format/20494>\
**Category:** Q&A\
**Tags:** pivot-table, formatting, Business-Intelligence-Engineer, quick-sight\
**Created:** [October 27, 2023, 1:07am UTC](https://community.amazonquick.com/t/how-to-show-totals-and-values-in-different-format/20494 "2023-10-27T01:07:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ales](https://avatars.discourse-cdn.com/v4/letter/a/a9a28c/32.png) [@Ales](https://community.amazonquick.com/u/Ales)\
**Post date:** [October 27, 2023, 1:07am UTC](https://community.amazonquick.com/t/how-to-show-totals-and-values-in-different-format/20494/1 "2023-10-27T01:07:41Z")

</div>

Hello everyone,  
In a pivot table, I would like to show the values and the totals in different formats. For example, I would like the Totals shown in percentage and the values in a different unit (in my case, _bps_).  
In the below example (portion of a table), everything is in _bps_ , but I would like the Totals shown in _%_.

![Screenshot 2023-10-27 100548](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/68f44d2792c9c49e3e8f4eb77b131f6dedfd85ea.png)

Can it be done without using an extra calculated field?  
Thank you

---

<div class="post-metadata">

**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\
**Post date:** [October 27, 2023, 8:02am UTC](https://community.amazonquick.com/t/how-to-show-totals-and-values-in-different-format/20494/2 "2023-10-27T08:02:04Z")

</div>

Hello Ales,

I do not think this is natively possible to change the total format resulting from the same measure. you may need to use custom field or similar chart with desired format of the measure that is being used.  
typically for changing the format or styles related to totals /sub totals are limited to changing labels names, positions, size, colors etc.

Please refer to [Totals and subtotals - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/format-tables-pivot-tables-totals.html#format-tables-pivot-tables-totals-apply) for more informations.

Hope this helps.

Cheers,  
Deepak