Site Map - skip to main content - dyslexic font - mobile - text - print

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes Monday through Friday.


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 >>

Host Image
Hosted by Ahuka on 2014-12-19 is flagged as Explicit and is released under a CC-BY-SA license.
Listen in ogg, spx, or mp3 format. | Comments (3)

Part of the series: 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-18T12:30:21Z 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-18T12:33:47Z by Steve Bickle

Last comment really belongs on ep 1655

OOPS!

Comment #3 posted on 2015-01-19T19:48:00Z 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 P in HPR stand for ?
Are you a spammer →
Who hosted this show →
What does HPR mean to you ?