Ask Your Question
0

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

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

bulrush gravatar image

updated 2015-08-24 18:35:48 +0100

Alex Kemp gravatar image
  • Libre office 4.2.2.1
  • 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
0

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

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
0

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

pierre-yves samyn gravatar image

Hi

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.

=TEXT(A2;"AAAA - MM")

screenshot

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.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 3,656 times

Last updated: Jul 13 '15