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