<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - Pivot Tables Sort Only on First Row or Column, and only after created"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117924#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - Pivot Tables Sort Only on First Row or Column, and only after created"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117924">bug 117924</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>(In reply to Jim Davis from <a href="show_bug.cgi?id=117924#c4">comment #4</a>)
<span class="quote">> If the only sort available after the table is created is to the first column
> or row then you should only show the sort option in the dropdown for the
> first row or column.
> </span >
Not true. Drag the fields for their title to get the desire order.
<span class="quote">> Additionally, you should remove the sort options from the data field options
> in the pivot table layout dialog since it is "expected" that sorts are only
> possible on the first row and/or column.
> </span >
Not true. It is for select the field's order not to sort the whole pt.
<span class="quote">> These two corrections would keep people from wasting time experimenting with
> presented options that are not intended to be functional.
> </span >
Or you don't want to understand/accept how it works, because it's not what you
like.
<span class="quote">> It "worksforme" with YOU because you have rearranged the columns. The sample
> I attached is in fact not the desired layout, but rather a workaround
> because sorts are only possible on the first columns and/or rows.
>
> The desired table result is as shown in the additional attachment BUT SORTED
> BY COLUMN TWO AND ROW TWO. The "Matrix to 3C" sheet is the copy, paste,
> sort, and reformat that is required because of the sort limitation, so I'm
> well aware of the problem and unfortunate workaround that you say
> "worksforme".
>
> Anything less requires a "workaround" and unnecessary time spent.
>
> I sense that you won't acknowledge it as a "bug" so I'll change this report
> to "VERIFIED", "WONTFIX".</span >
Yes their is no other way than to rearrange columns, and sort every field.
Sorting in the order col2-col3-col1, whit columns in pt positioned as
col1,col2,col3, at least looks a few awkward.</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>