topic Re: column headings in a new pivot table in App Development

column headings in a new pivot table

Bernhard_B — Tue, 22 Oct 2024 13:48:12 GMT

Is it possible to create a line break (long headings) for the column headings in a new pivot table (Visualization bundle)? I have already tried everything here.

Re: column headings in a new pivot table

Kushal_Chawda — Tue, 22 Oct 2024 14:15:23 GMT

@Bernhard_B Pivot Table does not provide a direct option to wrap text for column headers. However, you can achieve it using CSS if you have access to custom styling.

.qv-object-pivot-table .qv-st-header-cell { white-space: normal ; word-wrap: break-word ; text-align: center; }

Re: column headings in a new pivot table

Qrishna — Tue, 22 Oct 2024 21:26:34 GMT

increase the header row height using html/css or try vizlib if your company has its license and you can do line breaks in the text with chr(10) like below

= 'This is a long Header' & chr(10) & 'hence using a Line Break Using chr(10)' & chr(10) & 'And Another Line break for the display'

This can done to the field values too:

you can do line breaks on field values too wih same methods

if you want to give line breaks on an existing field name, try storing the field name in a variable and then do below:

try: = left('meas', 1) & chr(10) & mid('meas', 2, 1) & chr(10) & mid('meas', 3, 1) & chr(10) & right('meas', 1)