Ask Your Question

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

asked 2019-10-22 00:15:14 +0100

celiapgt gravatar image


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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-10-22 03:59:51 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more


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

celiapgt gravatar imageceliapgt ( 2019-10-26 16:47:35 +0100 )edit

To ask for an enhancement File an enhancement request.

m.a.riosv gravatar imagem.a.riosv ( 2019-10-26 20:24:03 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2019-10-26 20:34:45 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-22 00:15:14 +0100

Seen: 32 times

Last updated: Oct 22 '19