Ask Your Question

[Calc] Extracting Data from Spreadsheet [closed]

asked 2018-03-27 22:33:28 +0200

Dev Anthony gravatar image

It's been ages since I've done spreadsheet work so I'm not sure what to ask or search for. I have a large spreadsheet with a list of donations received by a charitable organization over the course of three years. Dates are entered in XX/XX/XX format. I'm looking for a way to automate the extraction of the following data:

By year -> By type -> Sum of each type.

By year -> By month -> By type -> Sum of each type.

For example:

2009: January
Cash: $5,000.00
Checks: $15,000.00
In Kind: $32,000.00
PayPal: $2,500.00

Is there a way this can be extracted through LibreOffice functionality, or will I have to calculate it all manually? If it can be done automatically, could you please let me know which function I'd use to do so? Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Dev Anthony
close date 2018-03-28 01:37:33.320140

1 Answer

Sort by » oldest newest most voted

answered 2018-03-28 00:19:17 +0200

m.a.riosv gravatar image

I think your friend in LibreOffice calc could be a Pivot Table, (Menu/Insert/Pivot Table or Menu/Data/Pivot Table/Create)

Please take a look at calc documentation Calc Guide chapter 8.

edit flag offensive delete link more


As soon as I saw you say "Pivot Table" it all came back to me in a flash. That's exactly what I'm after. Thank you!

Dev Anthony gravatar imageDev Anthony ( 2018-03-28 01:37:13 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2018-03-28 23:21:58 +0200 )edit

Question Tools

1 follower


Asked: 2018-03-27 22:33:28 +0200

Seen: 201 times

Last updated: Mar 28 '18