Ask Your Question
0

How to add subtotals in Pivot Table?

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

L-user gravatar image

updated 2015-08-28 22:37:38 +0200

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

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

Comments

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
1

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

karolus gravatar image

Drag&Drop YEAR into Column-fields

edit flag offensive delete link more

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 3,958 times

Last updated: Feb 02 '15