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

Powered by Comment Script