I have table I don’t want to show 3 levels of columns. I have a calculated field that aggregates the three keys as 1 column as a hidden sort key. {A}{B}{C} Now I want to place in the 2nd column unhidden the 3 hierarchy names wrapped in the cell on new lines. So in the first visual cell: “Level …

@sirwin007 how about something like this? concat("Level A: ", {A} , " ", "Level B: ", {B}, " ", "Level C: ", {C}) Seemed to work for me (maybe Im misunderstanding your question though…) [image] (ignore the color coding in the calc field editor - seems it is not picking up the new line as a con…

New Line (force wrap) in pivot cell

Question & Answer

sirwin007 September 21, 2022, 2:29pm 3

It actually does work, just not for me. I opened a support case. I was given a working demo and I replicated the simple code.

Render JSON as human readable pretty print

Display values of 2 fields one below other on the table

Topic		Replies	Views
Display values of 2 fields one below other on the table Question & Answer how-to	5	653	June 13, 2023
Wrapping long text fields without Paginated Reports Question & Answer paginated-reports	1	423	March 27, 2023
Converting a single comma separated row into multiple rows in QuickSight Question & Answer formatting , feature-request , calculations , how-to	8	1825	April 8, 2023
How can i add new column with values after spliting string values from one column based on id in table report? Question & Answer analysis , formatting , feature-request , calculations , how-to	3	747	May 17, 2023
Text in a pivot table Question & Answer formatting , calculations , Business-Intelligence-Engineer	7	439	January 23, 2024

New Line (force wrap) in pivot cell

Related topics