Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at


hpr1665 :: 44 - LibreOffice Calc - Working With Pivot Tables

When you have a pivot table, what are some of the things you can do with it to analyze your data?

<< First, < Previous, , Latest >>

Thumbnail of Ahuka
Hosted by Ahuka on 2014-12-19 is flagged as Explicit and is released under a CC-BY-SA license.
LibreOffice, Calc, Spreadsheet, pivot, tables. 3.
The show is available on the Internet Archive at: https://archive.org/details/hpr1665

Listen in ogg, spx, or mp3 format. Play now:

Duration: 00:10:52

LibreOffice.

In this in-depth series on LibreOffice we examine Writer, Calc and Impress

We take a look at one of the most powerful, but somewhat frightening, features of modern spreadsheets. But knowing the basics of pivot tables should make them a bit less frightening to the newcomer.


Comments

Subscribe to the comments RSS feed.

Comment #1 posted on 2015-01-18 12:30:21 by Steve Bickle

What version of LibreOffice was the example created in?

Ahuka,

Thats a really clear explanation of pivot tables, I'm sure I'll find a good use for these at some point. Thanks.

When trying to create a pivot table on the sample sheet you provided, It resulted in #VALUE errors in the totals of the resulting table. So I updated to the latest version of LibreOffice. I still had the same problem.

So then I then use a clean sheet with the data-set from sheet 1 of your example, then pivot tables worked fine as you described.

Hence the question about what version of LibreOffice was the sheet created with?

I ask because there may be a compatibility bug between versions that I should report.

Steve

Comment #2 posted on 2015-01-18 12:33:47 by Steve Bickle

Last comment really belongs on ep 1655

OOPS!

Comment #3 posted on 2015-01-19 19:48:00 by Kevin O'Brien

LibreOffice Version

It was 4.1.6.2. I know that is not the most current version, but I do these in advance and schedule them out.

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the letter P in HPR stand for?
Are you a spammer?
What is the HOST_ID for the host of this show?
What does HPR mean to you?