Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

On Fri, Jan 24, 2014 at 7:51 AM, Carl Paulsen <>wrote:

Dang, I hate the new list behavior of replying to the sender instead of
the list.  C

+1 there. I spammed Carl trying to reply and ask for feedback on
alternatives suggested to OP

Now from computer instead of phone

Yes pivot table can do that. I've used it many times. Have you tried the
Subtotal method I described?

Has anybody tried both Carl's method and mine?

It would be interesting if there's a consensus given OP's expectation of
unskilled users and intended outputs? Anybody?

After using both myself, and the pivot table MUCH more than the Subtotal
option I favor the Subtotals. Fewer clicks to get result, result displays
by adding rows to existing data no need to look somewhere else (another
tab) , using outline button can display rows of only customer name and
total purchase, then with outline and row expansion show purchase detail
for individual customer, once Subtotal has been applied totals and customer
detail can be displayed or hidden with one click, no need to open a menu,
it seemed users may be familiar with sort and up to clicking the "OK"
button on the Subtotal dialog this seems to me more similar to sort.
Other ideas?

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.