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

[saljain]

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:

Thanks!

[robert.eibers]

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

[robert.eibers]

Here an example with absolute value and % of:

For % I used percentOfTotal - Amazon QuickSight

[saljain]

This is a dummy data but I want to show both the metrics in a single cell. Thanks!

[robert.eibers]

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

[DeepakS]

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!