Ask Your Question

Pivot in Calc with Postgresql DB: How to group date columns [closed]

asked 2015-09-02 23:54:05 +0100

cschlaefcke gravatar image

updated 2020-08-25 00:17:16 +0100

Alex Kemp gravatar image


I have a postgresql database with a table containing booking data. I want to use this table to create a pivot in LO Calc (Version

In the row area I have a category field. In the column area a have the date field. And in the data area I have the field amount (Sum). Now I want to group the single date columns by month.

I tried to use the grouping function in Calc but it does not group anything or I was not able to use this function properly. I searched the LO docs and even here at - without success.

Any hint pushing me to right direction would be very much appreciated.



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-25 00:17:36.907354

1 Answer

Sort by » oldest newest most voted

answered 2015-09-03 21:18:07 +0100

cschlaefcke gravatar image

Solved by selecting one the date values in the date column. Then in the menu Data>Grouping and Outline>Group...

Here I was able to choose "Interval" = "Month" :-)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-09-02 23:54:05 +0100

Seen: 470 times

Last updated: Sep 02 '15