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.
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.
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.
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 :).