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!