How to add subtotals in Pivot Table?

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

L-user
2867 ●33 ●45 ●64

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

flag of United Kingdom of Great Britain and Northern Ireland

10354 ●14 ●38 ●38 http://etmg.altervista...

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

add a comment

1

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

m.a.riosv

19282 ●7 ●40 ●112

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

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

edit flag offensive delete link

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 ( 2015-02-03 07:02:33 +0100 )edit

add a comment

1

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

karolus

3813 ●13 ●35

Drag&Drop YEAR into Column-fields

edit flag offensive delete link

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 ( 2015-02-03 06:59:04 +0100 )edit

add a comment

How to add subtotals in Pivot Table?

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

How to add subtotals in Pivot Table? edit

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

How to add subtotals in Pivot Table?