Am 28.07.2015 um 08:39 schrieb HBarr:
Hi, I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is Item, D1 is Cost. I would like to extract the accumulated expenditure of an item and display it in F1. There are over 1,000 items. Help greatly appreciated. Hbarr
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
Substitute the term "Data Pilot" with "Pivot Table". -- 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