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


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

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



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” :slight_smile: