We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Pivot table, how to format dates as Monthname, Year? [closed]

asked 2015-07-12 18:00:43 +0200

bulrush gravatar image

updated 2020-08-22 23:34:49 +0200

Alex Kemp gravatar image
  • Libre office
  • Window 8 English

I have a tab in a spreadsheet with expense data. The relevant columns are: date (mm/dd/yyyy), category, amount. I made a pivot table in another spreadsheet tab. When I grouped by month, the pivot table only shows the month name. When I grouped by month and year, it shows the year in a row above the month names. How do I get each cell containing the month to show Monthname, Year? Short version of month is fine.

Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-22 23:35:18.974444

2 Answers

Sort by » oldest newest most voted

answered 2015-07-13 00:21:23 +0200

m.a.riosv gravatar image

Not with your version, it's a new feature in the next version 5 Release Notes

image description

edit flag offensive delete link more

answered 2015-07-13 08:59:47 +0200

pierre-yves samyn gravatar image


Until version 5.0 you can get the result in a single cell by adding a calculated column and using this column in the PivotTable.



Note: I use the "AAAA - MM" format (year before month) because the sort is alphabetical... Pivot.ods

If this answers the question, thank you to click on the ✔ to mark it ANSWERED.


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-07-12 18:00:43 +0200

Seen: 4,752 times

Last updated: Jul 13 '15