<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - PIVOTTABLE Allow use of text columns as Data Fields"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123727">123727</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>PIVOTTABLE Allow use of text columns as Data Fields
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.1.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>donaithnen@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Per the question asked here:
<a href="https://ask.libreoffice.org/en/question/86251/how-do-you-reference-text-in-a-pivot-table-data-field/">https://ask.libreoffice.org/en/question/86251/how-do-you-reference-text-in-a-pivot-table-data-field/</a>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>