I am trying to convert my file from my bank from Days to Months and not doable. Any suggestions
Please give us some more details, and upload a sample file here (delete the sensitive content from a copy of the original document before you upload it).
1 Like
I am running LibreOffice 7.552 on Zorin OS it is a Linux distribution. I saw what you did but my group and outline function does not work and
I do not seem to have expanded functionality in my pivot table. Is this due to my running Linux. I had also downloaded my bank statement for this year and simply wanted to sort by month.
Best Wishes
John
I have another question, when I downloaded my bank statement the dates that were shown, could be in text format. Do I have to change the format to dates in order for LibreOffice Calc to see it ?
I tried google sheets. I was able to download my bank statement create a pivot table choose month format over day format. Voila it worked. LibreOffice should be able to do the same but it seems to be very difficult for it to do.
No, in fact it is quite easy. Check option “detect special cells” in the csv import dialog.
Here I have another perfectly valid csv file for Google Sheets to try:
test.csv.ods (2.0 KB)
This forum does not allow uploading csv files. Just remove the wrong .ods suffix from the downloaded file.
I am running libreoffice linux. I tried the csv but the format defaults to 12 31 99 format and input different formats but it does not change it.
This is simply because you import dates as text values. Spreadsheet dates are formatted day numbers. The text “8/9/2023” is not a formatted number. It is just a text. It is not even clear if it refers to the 8th of September or 9th of August.
Ok thanks. I will look at it again
Have a closer look at that file by looking at it in a plain text editor or in the text import dialog.
What is the exact format of dates, currencies, plain decimals?
Are there any quotes around dates, currenies, decimals?
Is the format really
12 31 99
01 21 23
with spaces? Then select that imported text column and replace spaces with slashes.
Thank you for your help. I can now change the formats in dates. You solve one problem and another pops up.
1-2 January
1-3 January
1-4 January
I called one of my Excel friends and they said I need a formula for months. Anyway I am very grateful for your help.
Best Wishes
John
For the pivot table, drag the dates to “Row Fields”.
Then click any date in the pivot table, call menu:Data>Group>Group… (key F12) and group by month and years.
Thank you so much. It worked great. I am now working on subtotals. 
A pivot table can show all types of subtotals in the data fields for each combination of row and column fields. You can easily calculate sum, count, min, max, average, std. deviation in multiple data fields of one pivot table or as many pivot tables as needed. No need to use functions like SUBTOTAL or so called “database functions”.