Ask Your Question

cschlaefcke's profile - activity

2017-08-21 17:31:27 +0200 received badge  Famous Question (source)
2015-12-22 22:32:31 +0200 received badge  Popular Question (source)
2015-12-22 22:32:31 +0200 received badge  Notable Question (source)
2015-09-04 09:42:36 +0200 answered a question Pivot in Calc with Postgresql DB: How to group date columns

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" :-)

2015-09-03 09:30:39 +0200 asked a question Pivot in Calc with Postgresql DB: How to group date columns

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