In Excel, whenever I have dates, in Pivot Table, they are neatly grouped by months automatically. One can unwrap them to singular dates, but by default, they are grouped.
How do I do this in Libreoffice?
So far, I had to create another column, then create a formula to show me only the number of the month, possibly year and then use this column in the pivot table. This is tiering.
Is there a way to do grouping of months in Calc? If so, how?
And yes, dates are changed to format date, but it doesn’t change anything. Pivot tables in LO show all dates, and there is no grouping.
This is a very common usage, that we have a lot of business data with dates and want to compare or show them by months to assess it. I can’t believe there is no such functionality in LO.