Re: [libreoffice-users] Calc question

Alan B has written on 1/23/2014 9:58 PM:
> 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.

Wow!!! That's terrific!!!

Thanks so much!

-- 
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