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

Ask Your Question

How do you get subtotal labels on the 2nd and 3rd subtotals? [closed]

asked 2013-07-19 23:30:52 +0200

CPNewUser gravatar image

Am a new user trying to make subtotals readable. My logic is: subtotal 1 - using column Agt Type, count the rows add total to Agt Type column subtotal 2 - using column Agt Type, sum the totals of Fares and add it to the fares column subtotal 3 - using column Type, count the rows and add total to Type.

Attached are the Excel expample and what I have figured out for Libre. Why aren't there labels for the subtotals for group 2 and 3? Looking at this report, no one would know what was being subtotaled.

Am having issues with adding these files. If they are not attached please let me know.

Thanks, Connie

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-04 04:43:21.909167

2 Answers

Sort by » oldest newest most voted

answered 2013-07-25 22:49:25 +0200

CPNewUser gravatar image

Thank you for answering. I have been doing the Menu/Data/Subtotals and the calculations work. It's the labels that are missing. Should I be doing anything with the Subtotals_Sample.ods? Trying to do three levels of subtotals - count, sum, count. Could that be part of the problem?

Am running LO 4.0.4. Would that make a difference?

Any help would be greatly appreciated. Thanks!!!

edit flag offensive delete link more


In case others look for the answer...

If you are trying to Subtotal rows of data you are grouping by there is no Subtotal label.

In MarioSV's answer (and spreadsheet) Group by "Group" but Count any of the other columns and you'll get the label.

paulzag gravatar imagepaulzag ( 2015-09-16 03:54:37 +0200 )edit

answered 2013-07-20 01:36:02 +0200

m.a.riosv gravatar image

updated 2013-07-26 01:19:59 +0200

To upload files is needed some karma in the site. You can upload the file to specialized site as dropbox.

Find attached a sample of subtotal showing the subtotal labels, the subtotal is already configured. Menu/Data/Subtotal - Ok. Subtotals_Sample.ods

image description


Here changing to count+sum+count. image description

Labels are there.
Have you tried resetting the user profiles?, sometimes solve strange issues.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-07-19 23:30:52 +0200

Seen: 795 times

Last updated: Jul 26 '13