Description:
Per the question asked here: https://ask.libreoffice.org/en/question/86251/how-do-you-reference-text-in-a-pivot-table-data-field/

As of 6.0 there's still no way to create a pivot table using columns with text as Data Fields because all text values are ignored. If the text columns are added as Row Fields the text is carried over into the pivot table but rows with the same ID aren't combined.


Steps to Reproduce:
1.Create two sets of data with the same ID column and some shared IDs, but have one set of text columns for the first block of data and another set of columns for the second set of data.
2.Create a pivot table using the combined data.
3.Make the ID column a Row Field. If the text columns are included as Data Fields the values disappear. If they're included as Row Fields they're not combined.

Example
ID	Col1	Col2	Col3	Col4	Col5
1	Data 1 - 1	Data 2 - 1	Data 3 - 1		
1				Data 4 - 1	Data 5 - 1


Actual Results:
Text as Data Fields

ID	Count - Col1	Max - Col2	Product - Col3	Max - Col4	Var - Col5
1					

Text as Row Fields

ID	Col1	Col2	Col3	Col4	Col5	(empty)
1	Data 1 - 1	Data 2 - 1	Data 3 - 1	(empty)	(empty)	
	(empty)	(empty)	(empty)	Data 4 - 1	Data 5 - 1	



Expected Results:
ID	Col1	Col2	Col3	Col4	Col5
1	Data 1 - 1	Data 2 - 1	Data 3 - 1	Data 4 - 1	Data 5 - 1



Reproducible: Always


User Profile Reset: No



Additional Info:
The best way to address it would be either to have the Max or Min Data Field functions work on text, or to add a new Data Field function "Text" or "First" that would pick the first text field encountered for that column.