Ask Your Question
0

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

Hi,

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 5.0.1.2).

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 ask.libreoffice.org - without success.

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

Regards,

Christian

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
0

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

Stats

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

Seen: 470 times

Last updated: Sep 02 '15