Extracting values classes from an array

asked 2018-09-30 18:02:39 +0100

peeno gravatar image

Hi,

I would to do some bookkeeping with libreoffice. I downloaded my bankstatement and I am now able to open it in libreoffice. It creates a nice array of all the transaction. The columns in the array from left to right are labeled as followed: date, name (of the transaction partner), accountnumber (mine), accountnumber (other party), Transactiontypecode (twolettercode), from/to (if I got money or gave money), amount, mutationkind (how the mutation has been done), and anouncements (with information about the reason of the transaction and coding for local administrative properties)

I would like to extract info from this bank statement. There are, for example, multiple entries of payment to my landlord and I want them all extracted and summed up. Preferably without first sorting all the data, then copying the rows to a new place (new sheet or lower on the sheet) and then summing it all up. I have many transactions in this bankstatement (from the whole previous year) and it would take a lot of time to sort all this info by hand. Is there a way to extract all the info I want (so for example the summed amount of all payments to my landlord) without doing every class (landlord, phonepayment, gasoline, etc.) by hand? So for example by letting libeoffice search for a certain name of aacount an then summing all the instances?

edit retag flag offensive close merge delete

Comments

1

Try to choose Data - Pivot Table - Create. It seems to me that everything you described in your question will be done easily and quickly.

JohnSUN gravatar imageJohnSUN ( 2018-09-30 18:31:26 +0100 )edit