We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How to add subtotals in Pivot Table? [closed]

asked 2015-02-02 14:11:45 +0200

L-user gravatar image

updated 2020-08-15 15:03:08 +0200

Alex Kemp gravatar image

in LibreOffice Calc is there a way to add subtotals to Pivot Table? See below sample.
image description

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 2020-08-15 15:03:24.415945

2 Answers

Sort by » oldest newest most voted

answered 2015-02-02 23:50:05 +0200

m.a.riosv gravatar image

updated 2015-02-02 23:50:36 +0200

In edit-layout, double-click the row field in which you want the subtotal and select the subtotal operation.

edit flag offensive delete link more


Ahhh... this is really working. It is important to do the subtotals on PRODUCT data only, because adding subtotal on YEAR column has no effect in our sample.

Thanks a lot for this idea. It will make my life much easier.
+1 for your answer and also marking it as correct answer.

L-user gravatar imageL-user ( 2015-02-03 07:02:33 +0200 )edit

answered 2015-02-02 16:05:41 +0200

karolus gravatar image

Drag&Drop YEAR into Column-fields

edit flag offensive delete link more


For this very simple sample, this is working fine, but I actually have 10+ columns in real life and moving into Column-fields does not produces the result I like. Useful when there are small amount of columns.
+1 for your answer.

L-user gravatar imageL-user ( 2015-02-03 06:59:04 +0200 )edit

Question Tools

1 follower


Asked: 2015-02-02 14:11:45 +0200

Seen: 5,805 times

Last updated: Feb 02 '15