How to add both % and absolute values under the same cell in the Pivot Table Chart

Hi All,
How to display both % values and absolute values under the same cell in the pivot table chart. Please refer to the screenshot below:


Hey @saljain,

I don’t see the screenshot but you would need a calculation for the % of values field. percent of Total that should work

Here an example with absolute value and % of:
For % I used percentOfTotal - Amazon QuickSight

Screenshot 2024-01-25 at 9.56.25 AM
This is a dummy data but I want to show both the metrics in a single cell. Thanks!

Here is a similar case: Replace blank/NULL values by 0 - Question & Answer - Amazon QuickSight Community.
You would need something like: concat(tostring(sum(value)),’ ', tostring(percentoftotal*100), ‘%’)
Hope that helps you

Hi @saljain . Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!