Ask Your Question

Pivot table, how to format dates as Monthname, Year?

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

bulrush gravatar image

updated 2015-08-24 18:35:48 +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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 4,347 times

Last updated: Jul 13 '15