Build ID: 057fc023c990d676a43019934386b85b21a9ee99 CPU threads: 4; OS: Linux 5.0; UI render: default; VCL: gtk3; Locale: es-MX (en_US.UTF-8); UI-Language: en-US Calc: threaded
I want to show by semester or by 4-month periods the data (Sum of Value) in a pivot table for invoices.
In my source data sheet (same Calc spreadsheet) I have a column for date, a column for value, and a column for supplier.
I already groupped my dates column in pivot table as year and month, but I also require to have the data groupped by semester and 4-month periods.
Where do I put these new intervals? Do I need to ask for a macro to do it? Or is it impossible?