How can I create my own intervals to use in pivot tables grouping?

[LobaLuna]

Version: 6.3.0.4

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?

[mariosv]

Go to any cell of the date in the Pivot Table, and [F12] or Menu/Data/Group & Outline/Group, and select the intervals to apply.

edited 20200505

I think the easier it’s to add a column in the data source calculating the 4-month periods =INT((MONTH(B15)+3)/4) an another with the semester =INT((MONTH(B15)+5)/6).

[LobaLuna]

But in those intervals, Semester or 4-month periods do not exist. That’s why I ask how to ‘create’ them.

[mariosv]

To ask for an enhancement File an enhancement request.

[mariosv]

I think the easier it’s to add a column in the data source calculating the 4-month periods =INT((MONTH(B15)+3)/4) an another with the semester =INT((MONTH(B15)+5)/6).

[LobaLuna]

Thanks, @mariosv. Ithink you should put your solution on the Propose Your Solution section, so I can vote you and mark it as solved