Ask Your Question
0

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

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

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

m.a.riosv gravatar image

updated 2020-05-05 09:24:58 +0200

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

edit flag offensive delete link more

Comments

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

LobaLuna gravatar imageLobaLuna ( 2019-10-26 16:47:35 +0200 )edit

To ask for an enhancement File an enhancement request.

m.a.riosv gravatar imagem.a.riosv ( 2019-10-26 20:24:03 +0200 )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 +0200 )edit

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

LobaLuna gravatar imageLobaLuna ( 2020-05-05 05:05:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 105 times

Last updated: May 05