Re: Fwd: Re: [libreoffice-users] Calc question

What's a pivot table? Pointers to introductory tutorials will be
appreciated.

Thanks.
> -------- Original Message --------
> Subject:      Re: [libreoffice-users] Calc question
> Date:         Fri, 24 Jan 2014 07:50:14 -0500
> From:         Carl Paulsen <carlpaulsen@comcast.net>
> Reply-To:     cpaulsen@alumni.middlebury.edu
> To:   Alan B <aboba0@gmail.com>
>
>
>
> Isn't this the role of the pivot table?  That could provide a total for 
> both number (of purchases) and total of "price" if set up correctly.  
> Maybe I'm missing something here though.
> Carl
>
>
> On 1/23/14 9:58 PM, Alan B wrote:
> > On Thu, Jan 23, 2014 at 9:28 PM, Pikov Andropov<pikov22@gmail.com>  wrote:
> >
> > > Next to each buyer will be a price. How do I total the amount of a
> > > buyer's purchase "on the fly", so-to-speak?
> > >
> > > Have labels at the top of each column such as Buyer and Price.
> > Once you're ready to get your totals by buyer
> > 1) sort by buyer as you intend
> > 2) select the entire data range including the column labels
> > 3) from the menu select "Data | Subtotals..."
> > 4) in the Subtotals dialog box make sure the "Group by" option is "Buyer"
> > 5) tick the "Price" check box in the "Calculate subtotals for" list
> > 6) confirm "Sum" is the selected function in the "Use function" list
> > 7) click the "OK" button
> >
> > You'll be back to your spreadsheet with subtotals for each Buyer inserted.
> > Plus to the left of the row numbers you'll see outline features that allow
> > hiding and showing the various subtotaled rows.
> >
> > -Alan

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted