Ask Your Question
0

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 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 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
0

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
0

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

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

Question Tools

1 follower

Stats

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

Seen: 4,724 times

Last updated: Jul 13 '15