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 <carlpaul...@comcast.net> > Reply-To: cpaul...@alumni.middlebury.edu > To: Alan B <abo...@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<piko...@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+unsubscr...@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
