<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 - Wrong value in Pivot for a table"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138493">138493</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Wrong value in Pivot for a table
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>Roland.Dietz@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have a table with 11 columns. And I calculate a pivot table where one line is
obviously wrong and I found out what happens.
As fields for the lines I use a column called "Category" and as datafield I use
the sum of a column called "price".
There are two lines in my table one with category let's say 'X' and one with an
empty value in the column category. In this case the price for the line with
category field empty is counted in pivot to the category 'X'.
Actual Results:
see description
Expected Results:
Empty fields should be added to another pivot sum.
Reproducible: Always
User Profile Reset: No
Additional Info:
see description</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>