# How to add % to total without having to input an extra line item

**URL:** <https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [July 8, 2022, 6:10pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635 "2022-07-08T18:10:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jimatl1](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@jimatl1](https://community.amazonquick.com/u/jimatl1)\
**Post date:** [July 8, 2022, 6:10pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635/1 "2022-07-08T18:10:39Z")

</div>

How do you place a % to total next to an item? Currently I have to add a % line, for example:

Total Hires 13,929  
Total Late HSD Due to BGC 1,435  
% of Late HSD 10.3%

I would like to do this instead:  
Total Hires 13,929  
Total Late HSD Due to BGC 1,435 10.3%

---

<div class="post-metadata">

**Author:** ![Jesse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jesse/32/177_2.png) [@Jesse](https://community.amazonquick.com/u/Jesse)\
**Post date:** [July 8, 2022, 6:40pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635/2 "2022-07-08T18:40:19Z")

</div>

You could do this with Insight visuals, but not in a table or pivot table. Add an Insight and then put all 3 of your measures in the Values field well. Open the narrative and add 3 computations using the ‘Total Aggregation’ type. Then you can insert those values and whatever text you want (to insert the values, use the totalAggregate-\>formattedValue items)  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/03ab2f6ddb44f7b79d617cdc34206c3785599d35.png)

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/d5457c82d62caa9239d6ad285e69b5894ce877b1.png)

---

<div class="post-metadata">

**Author:** ![jimatl1](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@jimatl1](https://community.amazonquick.com/u/jimatl1)\
**Post date:** [July 8, 2022, 7:00pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635/3 "2022-07-08T19:00:02Z")

</div>

So there isnt a way to add to a table or pivot, correct?

---

<div class="post-metadata">

**Author:** ![Jesse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jesse/32/177_2.png) [@Jesse](https://community.amazonquick.com/u/Jesse)\
**Post date:** [July 8, 2022, 9:07pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635/4 "2022-07-08T21:07:34Z")

</div>

@jimatl1 That is correct

---

<div class="post-metadata">

**Author:** ![Jesse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jesse/32/177_2.png) [@Jesse](https://community.amazonquick.com/u/Jesse)\
**Post date:** [July 8, 2022, 9:08pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635/5 "2022-07-08T21:08:30Z")

</div>

I mean I guess in a table you could create a calculated field that uses string concatenation - the concat() function - to build it into one line. Then you can add that field as a dimension. Wont work in a pivot table though I dont think.

---

<div class="post-metadata">

**Author:** ![jimatl1](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@jimatl1](https://community.amazonquick.com/u/jimatl1)\
**Post date:** [July 8, 2022, 9:21pm UTC](https://community.amazonquick.com/t/how-to-add-to-total-without-having-to-input-an-extra-line-item/4635/6 "2022-07-08T21:21:47Z")

</div>

Thank you so much for the insight, much appreciated.