Site Map - skip to main content

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 Friday 2014-12-19 is flagged as Explicit and is released under a CC-BY-SA license.
Tags: LibreOffice, Calc, Spreadsheet, pivot, tables.

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.

Show Transcript

Automatically generated using whisper

whisper --model tiny --language en hpr1665.wav

<< First, < Previous, Latest >>


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.

<< First, < Previous, Latest >>

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 ?