Ask Your Question

LO Calc | pivot table | ability to group daily values by month, year... [closed]

asked 2017-08-27 22:51:21 +0200

Wololo gravatar image

updated 2017-08-27 22:53:45 +0200


I know from Office Excel 2007 the ability to "sum" daily values directly within the pivot table configuration windows. Does it exist in LO ?

Example, I have a transaction sheet (daily transactions) and i want to summarize them by month. In Office Excel 2007,

  1. I create a pivot table and set the "day" column of the sheet by row
  2. The pivot table appears with all values sum by day, e.g. values like 01/01/2017 or 01/02/2017
  3. I right-click on 01/02/2017, chose the "group" option and there i can choose for example Year and Month
  4. Result is a pivot table with monthly values by row grouped by year

see the picture for illustration image description

Thanks for your help

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Wololo
close date 2017-08-28 16:06:19.857357

1 Answer

Sort by » oldest newest most voted

answered 2017-08-28 01:14:43 +0200

robleyd gravatar image

Steps 1 and 2 as in your question

3 Click on a date

4 Select Data | Group and Outline | Group

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more


thank you very much, i had'nt found it on my own.

Wololo gravatar imageWololo ( 2017-08-28 16:05:45 +0200 )edit

Question Tools

1 follower


Asked: 2017-08-27 22:51:21 +0200

Seen: 579 times

Last updated: Aug 28 '17