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

[cschlaefcke]

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

[cschlaefcke]

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”