We're currently migrating from Ask to Discourse, read the details here

Ask Your Question
0

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

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

LobaLuna gravatar image

updated 2021-06-22 03:06:38 +0200

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-06-10 23:00:38.105595

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

Question Tools

1 follower

Stats

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

Seen: 247 times

Last updated: May 05 '20