how to show percentage below numbers in bracket in single measure in pivot table in qliksense

[indra]

how to show percentage below numbers in bracket in single measure in pivot table in qliksense

[MatheusC]

Could you provide a printout of how you are using this solution in your scenario?

Are you using the custom objects pivot table or the standard one – in the charts tab?

How you applied the CSS, used the multi KPI chart? Assigned a synthetic measurement value to the chart - for example = 1 and then in the style tab you applied the CSS code?

Since you pasted the expression into your pivot table chart, tell us what your result was ?

- Matheus

[Qrishna]

No need for extensions. you need Chr(10)  for a line break

just insert chr(10) inside the expression and increase the 'Wrap cell text' value:

=dual(round(sum(Sales)/sum(total Sales)*100) & '%' & chr(10) & '(' & round(sum(Sales)) &')',sum(Sales))